The following samples show you the syntax for exporting iSeries files to IFS files with DataExport/400.
 
To export the iSeries file QCUSTCDT in the QIWS library to the IFS file /DATA.TXT, use:
 
DBTODELIM FILE(QIWS/QCUSTCDT) FILNAM('/DATA.TXT') MBROPT(*REPLACE) RCDDLM(*CRLF) DTAFMT(*CSV) FLDDLM(*COMMA) COLHDG(*NO) QUOTES(*YES)
 
To use a SQL SELECT statement to export the iSeries file QCUSTCDT in the QIWS library to the IFS file /DATA.TXT, use:
 
DBSQLIFS SQL('SELECT * FROM QIWS/QCUSTCDT') IFSFILE('/DATA.TXT') MBROPT(*REPLACE) RCDDLM(*CRLF) DTAFMT(*CSV) FLDDLM(*COMMA) COLHDG(*NO) QUOTES(*YES)

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016