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

September 2, 2009 | Vol 8 Issue 17

 

In This Issue:  

Feature Article - Programming
 
Practical SQL: More Dynamic Selection Criteria

One of the most common issues in SQL is dealing with dates. This article will introduce you to the joys of dates, both legacy and date data type.

joe_plutaWritten by Joe Pluta

With the introduction of the date data type (and its siblings, the time and timestamp data types), the i5/OS database took a huge step forward. And although RPG's acceptance was a little more grudging, we eventually got to where we are today. However, if you're like many shops, you may have to deal with both legacy dates and date-type dates. And when you're talking about user-controlled queries, you still have to get those date values from the user via fields on the screen.


Read More >>

Feature Article - Programming
 
Use RPG String Manipulation Built-In Functions to Remove Spaces

Create a useful procedure to remove white space from strings in RPG.

tom_snyderWritten by Tom Snyder

In a previous article, I discussed how to use string manipulation built-in functions (BIFs) to process external files. I explained %TRIM, %TRIML, %TRIMR, %SUBST, %XLATE, %CHECK, and %CHECKR. But it was brought to my attention that I failed to mention the crucial string manipulation %SCAN BIF when an MC Press Online reader named Donna G. asked me, "Do you have any suggestions on how to strip out the blanks that are in the middle of data?" 


Read More >>

In the News


Read More >>

Support MC Press - Visit our Sponsors

 

Forums Sponsor

POPULAR FORUMS

Forums

 

 

Search Sponsor

 

POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM