IBM 000-8697 Manual de usuario descargar pdf (Pagina 506)

100

101

7-28 IBM Informix OnLine Database Server Administrator’s Guide

How to Create a Command File

The same character position can be repeated in a data ﬁeld deﬁnition, or in

different ﬁelds.

The scope of reference of null string is the data ﬁeld for which you deﬁne it,

but you can deﬁne the same null string for other ﬁelds.

Character-Position INSERT Statement

TheINSERTstatementwithindbloadcannotincorporateaSELECTstatement.

The user who executes dbload with this command ﬁle must have Insert

privilegeonthenamedtable.Arepresentationofthe syntax forthecharacter-

position INSERT statement follows:

Valid syntax for the dbload VALUES clause includes constants, literal

numbers, and functions as described in IBM Informix Guide to SQL: Reference.

- end isahyphen followed byan integer thatindicatesthe character

position within a data row that ends a range of character

positions.

ﬁeldn is a name that you assign to a data ﬁeld you are deﬁning with

the range of character positions.

ﬁlename is the name of the input ﬁle.

null string is a quoted string that speciﬁes the data value for which

dbload should substitute a null.

start is an integerthatindicates the characterpositionwithina data

row that starts a range of character positions.

column name is the column that receives the new data.

table name 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.

column

name

Restricted

Values Clause

INSERT

INTO

;

( )

table name

1 2 ... 501 502 503 504 505 506 507 508 509 510 511 ... 701 702

Comentarios a estos manuales

Sin comentarios

IBM 000-8697 Manual de usuario Pagina 506

Comentarios a estos manuales

Relacionado con productos y manuales para Software de base de IBM 000-8697