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

100

101

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 ﬁeld

names assigned by dbload. You must reference the automatically assigned

ﬁeldnameswiththeletterffollowedbyatwo-digitnumber: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

meaningofcol6inthenewstocktable.Sincethefourthcolumninnew_stock

(col4)isnot named inthecolumnlist,thenew data rowcontains a nullin the

col4 position (assuming that the column permits nulls).

The ﬁrst 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 ﬁle, cust_loc_data,

that contains the last four ﬁelds (city, state, zipcode, and phone) of the

customer table.

Column Value

col1 1

col2 baseball gloves

col3 SMT

col4 null

col5 case

col6 autographed

1 2 ... 499 500 501 502 503 504 505 506 507 508 509 ... 701 702

Comentarios a estos manuales

Sin comentarios

IBM 000-8697 Manual de usuario Pagina 504

Comentarios a estos manuales

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