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.
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.
Written 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).
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. >>
Consider the advantages of the Convert Hex to Character (cvthc) API.
Written 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.
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!