Hp Neoview Release 2.4 Software Manuale Utente Scaricare il pdf (Pagina 98)

Example A-11 Control File: Identity column

This example of defines an IDENTITY column. CUSTOMER_NUMBER can be any numeric data

type (SMALLINT, INTEGER, LARGEINT) column.

/*--------------------------------*/

/* IDENTITY column */

/*--------------------------------*/

mapexpr from dataformat1 to dataformat2

(

PHONE = PHONE,

SSN = SSN,

FIRST_NAME = FIRST_NAME,

LAST_NAME = LAST_NAME,

ADDRESS = ADDRESS,

ZIP = ZIP,

CUSTOMER_NUMBER = identity loader,

INFO1 = INFO1,

INFO2 = INFO2,

DATE_ENTERED = expression ("current_date")

)

98 Control File Examples

1 2 ... 93 94 95 96 97 98 99 100 101 102 103 ... 123 124

Commenti su questo manuale

Nessun commento