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

February 20, 2013 | Volume 12 Issue 4


TOP STORY: Enhance Your SQL Queries with User-Defined Table Functions
FEATURED ARTICLE: The API Corner: Diagnosing Decimal Data Errors
NEWS HIGHLIGHT: inFORM Decisions to Feature at IBM PureSystems and IBM i Enterprise Modernization Events
FORUM: CPYTOIMPF - Text Delimited?
EVENT: ASNA Visual RPG for .NET Windows 5-Day Beginning/Intermediate Class
Manage Subscription | Contact Us

Sponsor - ProData Computer Services, Inc.

Let 'em run WILD . . . with SQL!
Cover your developer's tracks and satisfy the demand for monitoring and controlling the interactive SQL environment with SQL Audit! This utility tracks modifications made to any IBM i database using ProData's SQL/Pro or IBM's SQL and helps you identify any problems with the results of your interactive SQL commands.

SQL Audit has you covered! 800.228.6318


Feature Article - Programming
Enhance Your SQL Queries with User-Defined Table Functions

Simplify your SQL SELECT statements, provide an interface to pass parameters to create dynamic tables, automatically log access to tables, and create a single point of maintenance for the SQL code you use repeatedly.

jim statonWritten by Jim Staton

In my previous article, "Reuse Your RPG Code with SQL User-Defined Functions," I discussed how you could reuse RPG business logic in SQL by taking an RPG program or service program that returns a single value and then using the SQL CREATE FUNCTION command to make the business logic available to any high-level language (HLL), such as PHP or Java, or any tool that uses SQL to access data on your system. There are times, however, when you might want a function that returns not just a single value but a set of values or even a table. In that case, you could consider using a User-Defined Table Function (UDTF).


Sponsor - The MC Press Bookstore

Get up to speed on today's RPG IV! Since its original publication, Programming in RPG IV has given thousands of students and professionals alike a strong foundation in the essentials of business programming using RPG IV. By focusing on real-world problems, down-to-earth solutions, and the latest style techniques, this book will make you stand out in the RPG marketplace. Available in print and eBook format. >> 


Feature Article - Programming
The API Corner: Diagnosing Decimal Data Errors

Consider the advantages of the Convert Hex to Character (cvthc) API.

bruce viningWritten by Bruce Vining

In developing a general-purpose utility to detect decimal data errors, we have made use of a few APIs. In the article "In Search of Decimal Data Errors," we saw how the List Fields (QUSLFLD) API can be used to find all numeric fields, within a user-specified file record format, that are defined as either zoned decimal or packed decimal. In addition to discovering the data type of each field, we were also able to determine the name of the field, the number of decimal positions, the number of digits to the right of the decimal point, the number of bytes used to store the field value, and the starting location of the field within the record format.


Sponsor - The MC Press Bookstore

Leverage Your Knowledge of RPG to Learn Java! Written by Phil Coulthard, lead architect for AS/400 application development projects at the IBM Toronto Laboratory, and George Farr, the technical development manager for RPG IV as well as VisualAge for RPG products, Java for RPG Programmers, Third Edition
teaches Java from an RPG programmer’s perspective. Get your copy today!


MC Press Industry Events Calendar

February 25th to March 1st:

ASNA Visual RPG for .NET Windows 5-Day Beginning/Intermediate Class :: Seminar


February 27th:

COMMON 2013 AIX Virtual Conference :: Webcast / Webinar


March 13th:

1:00 - 2:00 HTML5 & IBM i - Connect, Discover, Create :: Webcast / Webinar


March 19th to 21st:

RPG & DB2 Summit :: Conference


March 21st:

High Frequency Trading Conference :: Conference


All times Central Standard


Have an event you want to list? Send the information to today.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor



  Bookstore Sidebar Header