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.