dbimport使用手册

dbimport实用程序以dbexport实用程序生成的ASCII文件作为输入，建立数据库并装入数据。作为输入的ASCII文件分为两部分：用来重建数据库的模式文件，和数据库的数据文件。

dbimport  -v 显示软件版本号
*运行dbimport的用户将对所创建的数据库拥有DBA权限

dbimport实用程序的语法：
-c 指示dbimport在没有发生致命错误的情况下完成装入工作。
-q 指示在标准输出设备上不显示错误信息和警告。
-X 标识符符字段中的HEX二进制数据。

输入文件位置选项：
-i 指定存储ASCII文件和模式文件的磁盘目录，以便dbimport查找。
-t 指定含有ASCII文件和模式文件的磁带设备名。
-b 指定磁带设备块大小。block以KB为单位，该值必须能为所使用的设备接受。
-s 指定磁带的最大数据存储量。
-f 指定磁盘上模式文件的路径名，以便dbimport查找模式文件，并以此为输入建立数据库。

建库选项：
-d 指定用来存储新建数据库的OnLine数据库空间(dbspace)。如果没有使用-d选项指定dbspace，
则数据库缺省建立在根dbspace中。
-l 如果没有使用buffered参数，为装入的数据库建立无缓冲事务日志；如果使用了buffered参数，为装入的数据库建立有缓冲事务日志。-l选项等价于CREATEDATABASE语句的WITH LOG字句。如果没有使用-l选项，新建数据库不带日志。
-ansi 为装入的数据库建立ANSI方式兼容的事务日志。

---

>>-dbimport----------------------------------------------------->
 
     .---------.
     V         |                          (1)                      (2)
>--+---+-----+-+--| Input-File Location |-------| Create Options |-------database-+-><
   |   +- -c-+                                                                    |
   |   +- -q-+                                                                    |
   |   '- -X-'                                                                    |
   '- -V--------------------------------------------------------------------------'
 

Notes:

1. See page
2. See page

Element	Purpose	Key Considerations
-c	Instructs dbimport to complete importing even though it encounters certain nonfatal errors	References: For more information, see .
-q	Suppresses the display of error messages, warnings, and generated SQL data-definition statements	None.
-V	Displays product version information	None.
-X	Recognizes HEX binary data in character fields	None.
database	Specifies the name of the database to create	Additional Information: To use more than the simple name of the database, see the Database Names segment in the IBM Informix: Guide to SQL Syntax.

The dbimport utility can use files from the following location options:

• All input files are located on disk.
• All input files are located on tape.
• The schema file is located on disk, and the data files are on tape.

Important:

Do not put comments into your input file. Comments might cause unpredictable results when the dbimport utility reads them.

The dbimport utility supports the following tasks for a new Informix database server (excluding SE):

• Create an ANSI-compliant database (includes unbuffered logging)
• Establish transaction logging for a database (unbuffered or buffered logging)
• Specify the dbspace where the database will reside

The user who runs dbimport is granted the DBA privilege on the newly created database. The dbimport process locks each table as it is being loaded and unlocks the table when the loading is complete.

Global Language Support

When the GLS environment variables are set correctly, as the IBM Informix: GLS User's Guide describes, dbimport can import data into database versions that support GLS.

End of Global Language Support