RE: RPG prg - List Members from (*src) with Name, Type, and Text. ..

hi sriram,
you could do a 
DSPFD FILE(srclib/srcfile) TYPE(*MBRLIST) OUTPUT(*OUTFILE) OUTFILE(File2)

then you have all information on all members in your outfile.

Then,when you have query manager you can do a:
STRQMQRY   QMQRY(OLGHLPV4/SQLEUP) OUTPUT(*PRINT) + 
             SETVAR((LINE1 'SELECT SROBNM, SROBLI, +
             SROBAT,') (LINE2 'SRSROB, SRSRLI, + 
             SRSRMB') (LINE3 'FROM File2'))

The SQLEUP Query basically justs accepts the LINEx variables.
You then get a nice formatted SQL SELECT spool.

RUNSQLSTM *PRINT should work, too.

greets
 Martin





"Srinivasan, Sriram" <Sriram.Srinivasan@xxxxxxxxxxxx>
Gesendet von: rpg400-l-bounces@xxxxxxxxxxxx
26.08.2005 10:55
Bitte antworten an RPG programming on the AS400 / iSeries

 
        An:     RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
        Kopie: 
        Thema:  RE: RPG prg - List Members from (*src) with Name, Type, and 
Text. ..


Hi VenU,

Thanks, but I need to have all the members in a spool file not on screen. 
I
am interested to do this for a documentation purpose. 

Thanks once again,
Sriram Srinivasan