beautypg.com

A-11, Control file: identity column, Example a-11 – HP Neoview Release 2.3 Software User Manual

Page 92

background image

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")
)

92

Control File Examples