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 2, 2012 | Volume 11 Issue 9


TOP STORY: Practical SQL: Defining Your Data: TEXT and LABEL
FEATURED ARTICLE: RPG IV and a New Approach to Control-Break Processing
NEWS HIGHLIGHT: IBM Introduces New Foundation for Mobile Computing
ON-DEMAND WEBCAST: Beyond FTP, Securing and Automating File Transfers
EVENT: LANSA: Empowering Your Enterprise Systems Management Team
Manage Subscription | Contact Us

Feature Article - Programming
Practical SQL: Defining Your Data: TEXT and LABEL

Using DDL to define your data has a lot of benefits, but you still need to know a few tricks to get all of the features we enjoy in DDS. Read on for the secrets!

joe_plutaWritten by Joe Pluta

Today's article is my first dedicated to Data Definition Language (DDL), the specific SQL syntax used to define tables. It's counterpart in the green-screen world is Data Descriptions Specifications (DDS), the simple data definition language we've used forever.


Feature Article - Programming
RPG IV and a New Approach to Control-Break Processing

Essentially, what's old is new again!

jim_martinWritten by Jim Martin

Those of us who used the RPG cycle and L1, L2, etc. for control-break processing remember how slick it was. Very few lines of code were needed, since most of the work was being done by the cycle code. As we proceeded into full procedural programming, we became aware that more code was needed to get the same result. Typically, we now needed save fields of control-break key fields, code to load the save fields, logic to see if the control-break key fields in the file changed from the save fields, and then more logic to handle the last group. Also, the save data needed to be updated in our control-break routine. This is pretty standard stuff that has been around for a long time.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor