KB Article · 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:

You don't have the appropriate permissions.

Exporting iSeries Files to IFS Files with DataExport/400