Syntax of the UNLOAD statement

The UNLOAD statement in DB-Access unloads selected rows from a table into a text file.

Read syntax diagramSkip visual syntax diagram
>>-UNLOAD TO--'filename'--+----------------------+-------------->
                          '-DELIMITER'delimiter'-'   

                        (1)   
>--| SELECT Statement |----------------------------------------><

Notes:
  1. See SELECT statement.
Element Purpose Key Considerations
delimiter Character to use as delimiter Requirements: 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 UNLOAD statement.


Copyright© 2018 HCL Technologies Limited