Справочник Пользователя для IBM 000-8697

Utilities

7-31

How to Create a Command File

The following data rows would be inserted into the cust_address table:

Since the second column in cust_address (col2) is not named, the new data
row contains a null (assuming that the column permits nulls).

Consider the second

INSERT

statement in the character-position example:

INSERT INTO cust_sort

VALUES (area_cd, zip);

The following data rows would be inserted into the cust_sort table:

Since no column list is provided, dbload reads the names of all the columns
in cust_sort from the system catalog. Values to load into each column are
specified by field names from the previous

FILE

statement. You do not need

one

FILE

statement for each

INSERT

statement.

Column

Values from Row 1

Values from Row 2

col1

Sunnyvale++++++

Tempe++++++++++

col2

null

col3

col4

94086

85253