IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

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.

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:

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.

col1

1

col2

baseball gloves

col3

SMT

col4

null

col5

case

col6

autographed