7-26 IBM Informix OnLine Database Server Administrator’s Guide
How to Create a Command File
In this example, theVALUES clause uses the automatically assigned field
names assigned bydbload. You must reference the automatically assigned
fieldnames with the letter ffollowed 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
meaningof 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 intonew_stock from this INSERT statement is as
follows:
Character-Position FILE StatementFive sample data rows are introduced here and used throughout the
character-position discussion to illustrate theFILE 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, andphone) of the
customer table.
Column Value
col1 1
col2 baseball gloves
col3 SMT
col4 null
col5 case
col6 autographed