beautypg.com

Control file: multiple dataformats and maps – HP Neoview Release 2.3 Software User Manual

Page 87

background image

Example A-8 Control File: Multiple Dataformats and Maps

/*-----------------------------*/
/* Multiple Dataformats & Maps */
/*-----------------------------*/

version 1.0;

options
{
errors = 100,
discards = 100,
rowsetsize = 10
}

dataformats
{
dataformat1 delimited
records separated by
fields delimited by <,>
optionally qualified by <">
(
FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
SSN largeint,
INFO1 char,
INFO2 char
)

dataformat2 sql fields
(
FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
SSN largeint,
INFO1 char,
INFO2 char
)
dataformat3 delimited
records separated by
fields delimited by <,>
optionally qualified by <">
(
C1 int,
C2 int,
C3 char
)

dataformat4 sql fields
(
C1 int,
C2 int,
C3 char
)
}

sources {
src1 file "./data_files/sn_nvt.dat"

tgt1 jdbc table NEO.nvt.sn_nvt options

87