Querying the System Catalog Like DSPFD

Hey, Howard:

I liked your DSPDBR spreadsheet that called a stored procedure. Is it possible to do the same thing without calling the stored procedure, by querying the SYSTABLES or other system catalog file?

READ MORE >

Exchange Data the Easy Way with Windows File Shares

by Michael Sansoterra

There's nothing worse than doing something and later discovering there's a much simpler way. To my amazement and dismay, I recently learned that NetServer provides an elegant way for the iSeries to read and write files on a Windows file share.

READ MORE >

Reader Feedback and Insights: Don't Do Things On-the-Fly

Hey, Ted:

This may sound like I'm stuck in the mud, but I have always programmed, and been told to program, using documentation throughout. I stick to methods that can be tracked and stay away from doing things "on the fly". After all, when something goes wrong, you need a way to determine what went wrong, how data got destroyed or modified.