The ability to print a Run SQL Scripts result set and/or save it in Excel spreadsheet format has been on my wish list and that of others for a long time. V6R1 has fulfilled these wishes and by doing so has made Run SQL Scripts more functional and easier to use.

Print capability is now a standard function when a result set is displayed. However the Run SQL Scripts option to “Allow Save Results” must be selected to be able to save a result set in Excel or other file format. To select this option, click on Options in the

Last December, I shared four ways to avoid problems caused by the use of global data in RPG programs. I mentioned that a discussion of i 6.1 (or as I call it, V6R1) data-localization features would have to wait for another day. Well, that day is here.

With V6R1, it is possible to write programs that have no global identifiers. (By identifiers, I mean variables and constants. By variables, I not only mean scalar variables, but also arrays and data structures.) You only need to change two programming practices.

First, lose the RPG cycle. It breaks my

It looks like the links that you detailed in the Matryoshka Doll article on nested QOpenSys links probably occur after installing PASE on the iSeries. Check out this IBM document that very briefly discusses recursive /QOpenSys links in the AS/400 IFS. IBM doesn’t say why this happens, but at least it points the finger at what causes the problem.

–Bill Speicher

Earlier this year I wrote this article and a tip on one of the great mysteries of the AS/400 Integrated File System (AS/400 IFS). The purpose of the article was to explain why there are multiple /QOpenSys symbolic