Syntax of the LOAD Statement

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

Syntax of the LOAD Statement

You can use the LOAD statement in DB–Access to append rows to an existing table of a database.

>>-LOAD FROM--'filename'--+----------------------+-------------->
                          '-DELIMITER'delimiter'-'
 
                                 (1)
>--INSERT INTO--+-| Table Name |--------+----------------------->
                |                  (1)  |
                +-| Synonym Name |------+
                |               (1)     |
                '-| View Name |---------'
 
>--+------------------+----------------------------------------><
   |    .--------.    |
   |    V        |    |
   '-(----column-+--)-'

Notes:

See IBM Informix: Guide to SQL Syntax

Element	Purpose	Key Considerations
column	The name of a column to receive data from filename	Restrictions: Must be a column in the specified table or view.
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 LOAD statement, see the IBM Informix: Guide to SQL Syntax.