IBM 000-8697 ユーザーズマニュアル

IBM Informix OnLine Database Server Administrator’s Guide

The same character position can be repeated in a data field definition, or in
different fields.

The scope of reference of null string is the data field for which you define it,
but you can define the same null string for other fields.

The

INSERT

statement within dbload cannot incorporate a

SELECT

statement.

The user who executes dbload with this command file must have Insert
privilege on the named table. A representation of the syntax for the character-
position INSERT statement follows:

Valid syntax for the dbload

VALUES

 clause includes constants, literal

numbers, and functions as described in

eference.

is a hyphen followed by an integer that indicates the character
position within a data row that ends a range of character
positions.

is a name that you assign to a data field you are defining with
the range of character positions.

is the name of the input file.

is a quoted string that specifies the data value for which
dbload

should substitute a null.

is an integer that indicates the character position within a data
row that starts a range of character positions.

is the column that receives the new data.

is the name of the table that receives the data. The table name
can include the owner name but cannot include a database
server name.

Restricted

Values Clause

INSERT

INTO