Re: [Bulk] Re: Getting DDS for a DDL Generated File (or convince me its unnecessary)

On Thu, Jan 21, 2016 at 1:33 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 1/21/2016 12:41 PM, Luis Rodriguez wrote:

Ok. You can just forget using SQL to generate a list of file members :-(

Try using DSPFD for generating an outfile and processing it in your
SQLRPGLE program...

The QUSLMBR API works at 5.3 too.
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/apis/quslmbr.htm

Personally, I would be fighting and kicking to avoid working with
multi-member files but I feel morally obliged to share how I work with them.

QUSLMBR is nice to know, I guess, but in OP's position (looking for
SQL solution, ready to try RPG, will resort to Java if necessary), I
am strongly suspecting he doesn't already have system API wrappers set
up for this.

And if you're wrapping QUSLMBR from scratch, you probably also don't
have a ready-made way to EASILY work with user spaces, which is what
QUSLMBR uses to dump its output.

This approach is going to be thousands of times more difficult to set
up than Luis's suggestion of the old-school-but-dead-simple dump DSPFD
output to a file and read that file (using any means, including SQL).

Since we're apparently mentioning everything possible for the sake of
completeness, I feel morally obliged to mention that iSeriesPython 2.7
runs under V5R3 and is a nice way to integrate SQL, RPG-style
record-level access, CL commands, and calls to any *PGM object
including RPG programs, CL programs, and system APIs. For working with
user spaces, including arrays, it can use the (separately available)
utility module api2.py.

John Y.