|
|
|
The commands file specifies instructions for dbload to load the records into the table specified. Thus the commands file defines what dbload will be performing for a particular loading process.
There is no file naming convention for the commands file. For example, the commands file name to load the ORDERS table could be ORDERS_CMD.
The commands file must contain the following parts:
The syntax definition for the commands file is as shown:
dbload_commands:
define_record_statement
for_each_statement
The following is sample commands file showing load instructions.
DEFINE RECORD ord_rec AS
( ord_no, item_name, date, item_qty ) FIELD DELIMITER ' ' ;
FOR EACH RECORD ord_rec FROM ord_in
INSERT INTO ADMIN.orders (order_no, product, order_date, qty)
VALUES (ord_no, item_name, date, item_qty) ;
NEXT RECORD
The above commands specification instructs dbload to load records into the orders table. The fields in the data file, ORD_IN, appear in the order listed in the DEFINE RECORD statement.
