The LOAD and UNLOAD instructions

Informix® provides SQL instructions to export data from a database table and import data into a database table: The UNLOAD instruction copies rows from a database table into a text file; the LOAD instructions insert rows from a text file into a database table.

Genero db does not provide LOAD and UNLOAD instructions.

Genero db provides an Import/Export Utility (impexp) that will convert a specified set of tables, or an entire database, to or from a Comma Separated Value (CSV) external format.

Solution

In 4gl programs, the LOAD and UNLOAD instructions are supported with Genero db, with some limitations:

Note: When using Genero db versions before 3.80, there is a difference when you use Genero db DATETIME columns. DATETIME columns created in Genero db are equivalent to Informix DATETIME YEAR TO SECOND columns. In LOAD and UNLOAD, all Genero db DATE columns are treated as Informix DATETIME YEAR TO SECOND columns and thus will be unloaded with the "YYYY-MM-DD hh:mm:ss" format.