I consider myself to be a power user of Run SQL Scripts and use them for a variety of purposes, including ad hoc queries to do data analysis. Run SQL Scripts can be configured for your personal preferences (SQL default schema or current library, schema or library list, SQL or system naming convention, and other parameters) by clicking on Connection in the toolbar and then JDBC properties. Once you select your personal preferences and click the Connect button on the bottom of the JDBC Setup panel, your preferences are saved and become the default each time you invoke Run SQL

Is it possible for an RPG subprocedure to return more than one value? (I assume it isn’t; the RETURN opcode only allows for one argument.) I want to write a function subprocedure that will return a data structure of information taken from various database files. However, the subprocedure will also need to return a status code to indicate whether or not the I/O was successful. Do you have any suggestions?

–Travis

What you want to do is something like this:

eval (MyDataStructure: Status) = GetData (KeyValue)

No, that won’t work. But I can show you two other ways that will.

When decommissioning iSeries, System i, or Power i systems, there may be legal considerations in erasing disk drive data. Decommissioning can occur when removing disk drives from a system; when completing a Disaster Recovery Test on an outside provider’s machine; or when an i5/OS machine is sold or returned to a leasing company. The problem is that decommissioning disk drives can easily violate legally mandated compliance standards.

Compliance and Decommissioned Disk Drives

Like most systems, i5/OS data doesn’t necessarily disappear when you reinitialize your disk drives. Clever and determined hackers may be able to reconstruct supposedly erased data if they