Create Options: |--+----------------------------------------+-------------------| +-+-------------+--+-------------------+-+ | '- -d--dspace-' +- -l--+----------+-+ | | | '-buffered-' | | | '- -ansi-- -l-------' | '-+--------------------------+-----------' '- -l--logfile--+--------+-' '- -ansi-'
| Element | Purpose | Key Considerations |
|---|---|---|
| -ansi | Creates an ANSI-compliant database in which the ANSI rules for transaction logging are enabled | Additional Information: If you specify the -ansi option, you must also specify the -l logfile option. For more information about ANSI-compliant databases, see the IBM Informix: Guide to SQL Reference. |
| -d dbspace | Specifies the dbspace where the database is created.
The default dbspace location is the rootdbs.
|
Additional Information: For SE, the database is always in the current directory. |
| -l | Establishes unbuffered transaction logging for the imported database | References: For more information, see Database-Logging Mode. |
| -l buffered | Establishes buffered transaction logging for the imported database | References: For more information, see Database-Logging Mode. |
| -l logfile | Establishes transaction logging for the imported database and specifies the name of the transaction-log file | Restrictions: For SE,
the logfile filename must be an absolute
pathname or in the current directory.
References: For more information, see Database-Logging Mode. |
If you created a table or index fragment containing partitions in Dynamic Server 10.0 or a later version, you must use syntax containing the partition name when importing a database that contains multiple partitions within a single dbspace. See the IBM Informix: Guide to SQL Syntax for syntax details.
The following command imports the stores_demo database from the /usr/informix/port/stores_demo.exp directory. The new database is ANSI compliant, and the transaction-log file is specified as stores_demo.log in /usr/work.
dbimport -c stores_demo -i /usr/informix/port -l /usr/work/stores_demo.log -ansi
The following command imports the stores_demo database from the C:\USER\informix\port\stores_demo.exp directory. The new database is ANSI compliant, and the transaction-log file is specified as stores_demo.log in C:\USER\work.
dbimport -c stores_demo -i C:\USER\informix\port -l C:\USER\work\stores_demo.log -ansi