Category Archives for "SQL"

Send IBM i Email including SQL Table Data automatically

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data I […]

Continue reading
1

Update an IBM i file with SQL cursor using SQLRPGLE WHERE CURRENT OF

Using SQL in RPGLE programs is easier than you think. Making the move from RPG native file IO to SQL database IO is really quite straightforward.  Changing from good old READE loops to SQL FOR Loops simply means using the SQL CURSOR function. SQL has a groovy way of referring to what the stuff that […]

Continue reading

What’s the best Free RPG Editor?

If you are reading this blog then chances are you are (a) an RPG Programmer and (b) using SEU to edit your code and (c) you are frustrated that SEU wont syntax check new RPG anymore! It’s time to leap into an RPG EDITOR or be pushed… RDi is bloody good but it’s also a very expensive code […]

Continue reading

RPG, PHP and MYSQL

I wish I could take credit for this article. But I cant 🙂  It hits the nail on the head and the author (Daniel Gray) explains himself very clearly: Getting up to speed with PHP on the IBM I If I can, I’d like to offer my IBM I friends some advice on getting up […]

Continue reading
RPG Modernization

AS400 Modernization starts with Modernizing RPG Applications

Modernizing RPG Programs – Learn the RPG History first I had email email from an old work colleague this morning. He was a windows programmer, with limited exposure to RPG, but works in a company that is driven by a huge, old, complex RPG3 application that has changed little over the last decade. He is […]

Continue reading
1 2 3 4