IBM 000-8697 Benutzerhandbuch
7-26
IBM Informix OnLine Database Server Administrator’s Guide
How to Create a Command File
In this example, the
VALUES
clause uses the automatically assigned field
names assigned by dbload. You must reference the automatically assigned
field names with the letter f followed by a two-digit number: f01, f02, f10, and
so on. All other formats are incorrect.
field names with the letter f followed by a two-digit number: f01, f02, f10, and
so on. All other formats are incorrect.
The user has changed the column names, the order of the data, and the
meaning of col6 in the new stock table. Since the fourth column in new_stock
(col4) is not named in the column list, the new data row contains a null in the
col4
meaning of col6 in the new stock table. Since the fourth column in new_stock
(col4) is not named in the column list, the new data row contains a null in the
col4
position (assuming that the column permits nulls).
The first data row inserted into new_stock from this
INSERT
statement is as
follows:
Character-Position FILE Statement
Five sample data rows are introduced here and used throughout the
character-position discussion to illustrate the
character-position discussion to illustrate the
FILE
statement syntax and
function.
The examples in this section are based on an input data file, cust_loc_data,
that contains the last four fields (city, state, zipcode, and phone) of the
customer
that contains the last four fields (city, state, zipcode, and phone) of the
customer
table.
Column
Value
col1
1
col2
baseball gloves
col3
SMT
col4
null
col5
case
col6
autographed