MAGAZINES

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

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. 


Read More >>

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.


Read More >>

Support MC Press - Visit Our Sponsors

 

 Popular Forums

POPULAR FORUMS

Forums

 

   Search Sponsor

 

 POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM