Exporting iSeries Files to IFS Files with DataExport/400 · Customer Portal

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