Home
Migrating and upgradingYou can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix®. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix® database server can affect upgrading from a previous release.
Migrating Informix® database systemsThe Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
Data migration utilities
The LOAD and UNLOAD statementsYou can use the SQL LOAD and UNLOAD statements to move data. The LOAD statement is moderately fast and easy to use, but it only accepts specified data formats. You usually use the LOAD statement with data that is prepared with an UNLOAD statement.
Syntax of the LOAD statementThe LOAD statement in DB-Access appends rows to an existing table of a database.

Syntax of the LOAD statement

The LOAD statement in DB-Access appends rows to an existing table of a database.

Notes:

¹ See Identifier.


Element	Purpose	Key Considerations
column	The name of a column to receive data from filename	Must be a column in the specified table or view.
delimiter	Character to use as delimiter	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 LOAD statement.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.