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

November 21, 2012 | Volume 11 Issue 21


TOP STORY: Reuse Your RPG Code with SQL User-Defined Functions
FEATURED ARTICLE: The API Corner: Processing the QLOCALE System Value
NEWS HIGHLIGHT: IBM WebSphere Message Broker V8.0.0.1 License Entitlements Extended
MC STORE: Top 10 Best-Selling Titles
EVENT: ARCAD-Rational Power Pack
Manage Subscription | Contact Us

Feature Article - Programming
Reuse Your RPG Code with SQL User-Defined Functions

What? You haven't used a UDF before? No worries. There's nothing to it.

jim statonWritten by Jim Staton

Recently, one of our programmers came to me with a question about retrieving some information from our iSeries. He was using a business intelligence (BI) tool to analyze picking errors across several warehouses, and he needed a way of retrieving the warehouse area for a specific warehouse and item location. Unfortunately, that information was not in a table in our system, but rather was calculated by an RPGLE program and returned as a parameter when the program was called with the warehouse ID and the item location. Because the BI tool used SQL to retrieve information from our iSeries, I suggested that he consider creating an SQL User-Defined Function (UDF) to return the warehouse area. With this method, the warehouse area can be returned as a value by any high-level language, such as PHP or Java, or any tool that uses SQL to access data on the system.


Feature Article - Programming
The API Corner: Processing the QLOCALE System Value

Find out how to use internationalized IFS path names.

bruce viningWritten by Bruce Vining

This is the fourth in a series of articles related to dynamically accessing and processing system values. In the first article, "In Search of System Values," we saw how the Retrieve Command Definition (QCDRCMDD) API could be used to access the list of valid system values for the release of the IBM i our program is running on. This list of valid system values was retrieved by using the IBM-provided Display System Value (DSPSYSVAL) command and by then accessing the list of special values associated with the SYSVAL keyword.


In the News

Support MC Press - Visit our Sponsors

Forums Sponsor



Search Sponsor