After reading this article, you'll never worry about date formats again.
Written by Tom Snyder
My recent articles on exporting data have generated a number of questions on formatting dates with SQL. So let's explore SQL dates by looking at how to create date fields in physical files, insert dates into physical files, and export the dates in different formats.
Use the QCMDEXC, system, and QCAPCMD APIs to run CL commands from within your RPG application.
Written by Bruce Vining
In last month's column, "Do I Really Need to Call a CL Program to Perform This Function?," the QCMDEXC, system, and QCAPCMD APIs were introduced. All three of these APIs are available to enable the running of CL commands from an application program. Today, we'll look at what is required to implement these APIs within your application program as well as some of the considerations that exist with each of the APIs.