IBM 000-8697 Manuel d'utilisateur télécharger pdf (Page 509)

100

101

Utilities 7-31

How to Create a Command File

The following data rows would be inserted into the cust_address table:

Since the second column in cust_address (col2) is not named, the new data

row contains a null (assuming that the column permits nulls).

Consider the second INSERT statement in the character-position example:

INSERT INTO cust_sort

VALUES (area_cd, zip);

The following data rows would be inserted into the cust_sort table:

Since no column list is provided, dbload reads the names of all the columns

in cust_sort from the system catalog. Values to load into each column are

speciﬁed by ﬁeld names from the previous FILE statement. You do not need

one FILE statement for each INSERT statement.

Column Values from Row 1 Values from Row 2

col1 Sunnyvale++++++ Tempe++++++++++

col2 null null

col3 CA AZ

col4 94086 85253

Column Values from Row 1 Values from Row 2

col1 408 null

col2 94086 85253

1 2 ... 504 505 506 507 508 509 510 511 512 513 514 ... 701 702

Commentaires sur ces manuels

Pas de commentaire

IBM 000-8697 Manuel d'utilisateur Page 509

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel de base de données IBM 000-8697