SQL adaptation guide For Genero db 3.6x, 3.8x / BDL programming |
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.
In 4gl programs, the LOAD and UNLOAD instructions are supported with Genero db, with some limitations: