If you cannot use onunload and onload, you have three other methods to choose from:
All these methods enable you to modify the database schema. The dbexport and dbimport utilities provide some flexibility, but you must move an entire database.
If you cannot use onunload and onload to export and import data, you can unload your data to text files. You can use the dbexport utility to unload data to tape from any of the following database servers:
The UNLOAD statement lets you manipulate the data as you unload it, but it requires that you unload to files on disk instead of to tape. If you unload to disk files, you might need to use UNIX, Linux, or Windows utilities to load those files onto tape.
The dbexport utility unloads a database into text files and creates a schema file. You can use the schema file with dbimport to re-create the database schema in another IBM Informix environment. You can edit the schema file to modify the database that dbimport creates. The dbexport utility supports Dynamic Server 10.0, 9.40, 9.30, and 9.2x data types.
The dbexport utility supports the following destination options:
The dbimport utility creates a database and loads it with data from text files. The input files consist of a schema file that is used to re-create the database and data files that contain the database data. Normally, you generate the input files with the dbexport utility, but you can use any properly formatted input files. The dbimport utility supports new data types in Dynamic Server 10.0, 9.40, 9.30, and 9.2x.
The dbimport utility can use files from the following location options:
The dbimport utility supports the following options for a new IBM Informix database server: