Utilities 7-31
How to Create a Command File
The following data rows would be inserted into thecust_address table:
Since the second column incust_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 thecust_sort table:
Sinceno column list is provided, dbload reads the names of all the columns
incust_sort from the system catalog. Values to load into each column are
specified by field names from the previousFILE statement. You do not need
oneFILE statement for each INSERT statement.
Column Values from Row 1 Values from Row 2
col1 Sunnyvale++++++ Tempe++++++++++
col2 null null
col3 CA AZ
col4 94086 85253
Column Values from Row 1 Values from Row 2
col1 408 null
col2 94086 85253