IBM 000-8697 Manual do Utilizador descarregar pdf (Página 505)

100

101

Utilities 7-27

How to Create a Command File

Fields in the input ﬁle are padded with blanks (represented by + in the

following example) to create data rows in which the locations of data ﬁelds

andthenumberofcharactersarethesameacrossallrows.Thedeﬁnitionsfor

these ﬁelds are CHAR(15), CHAR(2), CHAR(5), and CHAR(12), respectively.

For your reference, the character positions and ﬁve example data rows from

the cust_loc_data ﬁle are displayed:

1234567890123456789012345678901234

Sunnyvale++++++CA94086408-789-8075

Denver+++++++++CO80219303-936-7731

Blue Island++++NY60406312-944-5691

Brighton+++++++MA02135617-232-4159

Tempe++++++++++AZ85253xxx-xxx-xxxx

The following example of a dbload command ﬁle illustrates the character-

position form of the FILE and INSERT statements. The example includes two

new ﬁles, cust_address and cust_sort,to receive thedata. For thepurpose of

this example, cust_address contains four columns, the second of which is

omitted from the column list. The cust_sort table contains two columns.

FILE cust_loc_data

(city 1-15,

state 16-17,

area_cd 23-25 NULL = "xxx",

phone 23-34 NULL = "xxx-xxx-xxxx",

zip 18-22,

state_area 16-17 : 23-25);

INSERT INTO cust_address (col1, col3, col4)

VALUES (city, state, zip);

INSERT INTO cust_sort

VALUES (area_cd, zip);

The syntax for the character-position FILE statement can be represented as

follows:

: start -

end

);

FILE ﬁlename

ﬁeldn start

NULL =

"null string"

(

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

Comentários a estes Manuais

Sem comentários

IBM 000-8697 Manual do Utilizador Página 505

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados IBM 000-8697