Home | Previous Page | Next Page   Data Migration Utilities > The dbload Utility >

Syntax of the dbload Command

Read syntax diagramSkip visual syntax diagram>>-dbload------------------------------------------------------->
 
>--+--------------------------------------------------------------------+-><
   | .-------------------------.  .--------------------------.          |
   | V                         |  V                          |          |
   +---+- -d--database-------+-+----+----------------------+-+--+-----+-+
   |   +- -c--command file---+      +- -r------------------+    '- -s-' |
   |   '- -l--error log file-'      +- -k------------------+            |
   |                                +- -e--errors--+-----+-+            |
   |                                |              '- -p-' |            |
   |                                +- -i--ignore rows-----+            |
   |                                +- -n--commit interval-+            |
   |                                '- -X------------------'            |
   '- -V----------------------------------------------------------------'
Element Purpose Key Considerations
-c command file Specifies the filename or pathname of a dbload command file References: For information about building the command file, see Command File for dbload.
-d database Specifies the name of the database to receive the data Additional Information: If you want to use more than the simple name of the database, see the Database Name section of the IBM Informix: Guide to SQL Syntax.
-e errors Specifies the number of bad rows that dbload reads before terminating . The default value for errors is 10. References: For more information, see Bad-Row Limit.
-i ignore rows Specifies the number of rows to ignore in the input file References: For more information, see Rows to Ignore.
-k Instructs dbload to lock the tables listed in the command file in exclusive mode during the load operation References: For more information, see Table Locking.

Restrictions: You cannot use the -k option with the -r option because the -r option specifies that no tables are locked during the load operation.
-l error log file Specifies the filename or pathname of an error log file Restrictions: If you specify an existing file, its contents are overwritten. If you specify a file that does not exist, dbload creates the file.

Additional Information: The error log file stores diagnostic information and any input file rows that dbload cannot insert into the database.
-n commit interval Specifies the commit interval in number of rows

The default interval is 100 rows.

 Additional Information: If your database supports transactions, dbload commits a transaction after the specified number of new rows is read and inserted. A message appears after each commit.

References: For information about transactions, see the IBM Informix: Guide to SQL Tutorial.
-p Prompts for instructions if the number of bad rows exceeds the limit References: For more information, see Bad-Row Limit.
-r Prevents dbload from locking the tables during a load, thus enabling other users to update data in the table during the load Additional Information: For more information, see Table Locking.

Restrictions: You cannot use the -r option with the -k option because the -r option specifies that the tables are not locked during the load operation while the -k option specifies that the tables are locked in exclusive mode.
-s Checks the syntax of the statements in the command file without inserting data Additional Information: The standard output displays the command file with any errors marked where they are found.
-V Displays product version information None.
-X Recognizes HEX binary data in character fields None.
Tip:
If you specify part (but not all) of the required information, dbload prompts you for additional specifications. The database name, command file, and error log file are all required. If you are missing all three options, you receive an error message.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]