In this installment of our continuing series on using SQL in real business applications, we introduce the concept of invoking service programs from within SQL.
Written by Joe Pluta
We continue to provide you with examples of integrating SQL with traditional RPG. In this article, we're going to focus on how we can use a service program to extend SQL and provide an essential feature that SQL is sorely lacking: converting binary data in a character field to numeric values. Note that this is the opposite of something like the HEX function, which returns the hexadecimal representation of a field. This function will take some alphanumeric data, either in packed or binary form, and return the numeric value the data represents. This practical extension to SQL can be used by any shop.
Discover the essence and usage of the COL associated with a library.
Written by Junlei Li
In the reply post in 2009 to a question called "Best Way to Check if a Library Has At Least 1 Changed Object" in the midrange-l mailing list, CRPence mentioned the term "changed object list" (COL). The following is the original reply post by CRPence. (Sorry, Chuck, I don't know your full name.)
Written by Joe Pluta
Written by Junlei Li