The Create SQL Function from the article SQL Cross Platform Interoperability: The Proper Function creates a CLE *srvpgm on the iSeries. Can this be accessed from an RPGLE program? If so, what would the prototype look like? I am not familiar with C and cannot get this to work, so far, on my own.

–Gene

Note: The code accompanying this article can be downloaded here.

This astute reader noticed that when creating an SQL-based function, DB2 generates an ILE C service program behind the scenes. This prompted the reader to inquire if there was a way to call the

When using RSE for editing my CL, DDS, RPG or COBOL code, I find that I can save a lot of time by using keyboard shortcuts for functions that would otherwise require that I take my hands off the keyboard to use the mouse. So I thought I would share a few of my favorites. Many of the shortcuts I use are standard for other Windows-based applications that I also use for email, spreadsheets or text editing.

These include some very common ones such as:

• Ctl-C to copy, Ctl-V, or Shift-Insert to paste, and Ctl-X or Shift-Delete to cut.

Nice article on five things that kill backups. In regards to auditing backup results, however, I find it a little tedious to check joblogs as you recommended. I prefer to use the Display Log command for reviewing the system history log to check backup results. It’s easy to spot missed objects from this display. I also like to use the Display Backup List command (DSPBCKUPL) for Sarbanes-Oxley compliance.

–Bill

Thanks, Bill for bringing up two ideas I hadn’t thought of when I wrote that article. Here are the details on what Bill is discussing and how it can help