System i Expert Trevor Perry & KMR Systems select WebSmart PHP & Nexus Portal for Web Application Development - See Why ! Get to the Web faster with WebSmart, the solution thousands of RPG developers use to succeed. Only WebSmart lets you develop System i web apps in PHP or RPG CGI, host on System i, IBM Power Systems, Linux, Unix and/or Windows, access DB2, MS SQL & MySQL.... Read Trevor's comments & Try WebSmart for Free !
Format and name derived columns when you use SQL to do ad hoc analysis of information in an SQL table.
By Skip Marchesani
I frequently use Interactive SQL or Run SQL Scripts in Navigator to do ad hoc analysis of information in an SQL table, which often results in one or more new columns being derived or created based on existing columns. When I first began doing these types of queries, I was frustrated with the way SQL identified and formatted a derived column in the result set.
Integers fields are a fantastic way to store relatively large numbers in a small space, but getting RPG to play nice isn't always easy.
By Joe Pluta
There are times when RPG simply leaps forward into the future and times when it needs a little cajoling. The whole concept of ILE was a quantum leap. Integer support, a little less so.
By Skip Marchesani 
By Joe Pluta