Syntax of the UNLOAD Statement

Home | Previous Page | Next Page Data Migration Utilities > The LOAD and UNLOAD Statements >

Syntax of the UNLOAD Statement

You can use the UNLOAD statement in DB–Access to unload selected rows from a table into a text file.

>>-UNLOAD TO--'filename'--+----------------------+-------------->
                          '-DELIMITER'delimiter'-'
 
                        (1)
>--| SELECT Statement |----------------------------------------><

Notes:

See the IBM Informix: Guide to SQL Syntax.

Element	Purpose	Key Considerations
delimiter	Character to use as delimiter	Restrictions: See Syntax for the Delimiter Form
filename	Specifies the input file	None.

This syntax diagram is only for quick reference. For details about the syntax and use of the UNLOAD statement, see the IBM Informix: Guide to SQL Syntax.