1. Manuals
  2. Brands
  3. Computer Equipment
  4. Server
  5. IBM
  6. Computer Equipment
  7. Server

IBM 000-8697 - page 509

1 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 702
Download on canonical page 702 pages, 4.15 Mb
Utilities 7-31
How to Create a Command File
The following data rows would be inserted into thecust_address table:
Since the second column incust_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 thecust_sort table:
Sinceno column list is provided, dbload reads the names of all the columns
incust_sort from the system catalog. Values to load into each column are
specified by field names from the previousFILE statement. You do not need
oneFILE 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
MENU

Models

Contents