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

August 15, 2012 | Volume 11 Issue 15


TOP STORY: An SQL Function That Brings Back Memories of the Past
FEATURED ARTICLE: The API Corner: In Search of System Values
NEWS HIGHLIGHT: mrc Launches Cloud Partnership Program for ISVs
WHITE PAPER: 6 Recommendations for Smarter Spooled File Processing on Your IBM i
EVENT: Web-enabling the iSeries Platform for AP Automation 
EVENT: Ad-Hoc File Transfers Using GoAnywhere Secure Mail
Manage Subscription | Contact Us


Programming - SQL
An SQL Function That Brings Back Memories of the Past

Not everything that's old is outdated!

jim statonWritten by Jim Staton

In my previous article, I discussed the goals I had set out for our programming group and how those goals helped determine the skills that I was looking for among the candidates for a job in our company. One of those goals was to encourage the use of SQL among our programmers for database I/O.


There are lots of reasons for this, including the facts that SQL is a standard database access language that can be used across many systems and programming languages and that the SQL query engine is the only one that IBM is enhancing on the IBM i to improve efficiency in data access.


Programming - APIs
The API Corner: In Search of System Values

Determine the system values defined for your system.

bruce viningWritten by Bruce Vining

I recently received a note from Paul T. asking "if there is an API which will retrieve a list of system values and their current values." To this I (all too quickly) referred him to the Retrieve System Values (QWCRSVAL) API, which retrieves the value associated with a list of one or more system values. Paul then got back to me with, "I was looking for something that would return the list of system values available"—which I admit is in his original question, but was totally missed by me.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor