List all file members from a multi member AS400 File
I need to be able to retrieve a list of the members of a multi member file so that I can process the members that meet certain criteria. I need to be able to do this from a PC application.
If there is anyone with any ideas I would be grateful.
Thanks
Software/Hardware used:
iSeries, SQL Server, ODBC, SSIS, FTP,
If there is anyone with any ideas I would be grateful.
Thanks
Software/Hardware used:
iSeries, SQL Server, ODBC, SSIS, FTP,
ASKED:
May 14, 2010 6:37 PM
UPDATED:
May 15, 2010 1:04 AM
Answer Wiki:
Either of these DSPFD commands should work for you:<pre>
DSPFD FILE( mylib/myfile ) TYPE( *MBR ) OUTPUT(*OUTFILE) OUTFILE( somelib/mymbr )
DSPFD FILE( mylib/myfile ) TYPE( *MBRLIST ) OUTPUT(*OUTFILE) OUTFILE( somelib/mymbrlist )</pre>
Run a couple tests to QTEMP and use RUNQRY to view the differences. Choose the variation that you need.
From a PC, the commands could be executed with RMTCMD or through a stored proc CALL to QSYS.QCMDEXC or a few other ways.
Tom
========================================================
Use the i5 command DSPFD to output to an *OUTFILE:
ex: DSPFD FILE(library/file) TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(library/file)
Then use query to sort the data to your specs or just access the output file directly from your PC app.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
