Filter
Top Products
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 nameswith 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
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 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 table.
Column Value
col1 1
col2 baseball gloves
col3 SMT
col4 null
col5 case
col6 autographed