MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

May 7, 2008 | Vol 7 Issue 9


In This Issue:

>> Working with Derived Columns

>> Integers and RPG

Sponsor - Business Computer Design

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 !



Feature Article - Programming
Working with Derived Columns

Format and name derived columns when you use SQL to do ad hoc analysis of information in an SQL table.

skip_marchesani.jpgBy 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. 


Feature Article - Programming
Integers and RPG

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.

joe_pluta.jpgBy 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.


Support MC Press - Visit Our Sponsors


 Popular Forums




   Search Sponsor