Enhanced initial load sample control file – HP Neoview Release 2.5 Software User Manual
Page 117
Example B-4 Enhanced Initial Load Sample Control File
version 1.0;
options { errors = 1000,
rowsetsize = 5000,
commitsize = 1000000,
}
dataformats
{
dataformat1 delimited
records separated by <nl>
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
)
}
sources {
src1 file "./data_files/sn_nvt_01.dat" options (inlinesort = "true", sorted = "true")
tgt1 jdbc table NEO.nvt.sn_nvt
options
(
exceptiontable = "myexceptiontable",
system = "asl0101",
user = "gcscsup",
password = "transport",
url = "jdbc:hpt4jdbc://ip:port/"
)
}
maps {
map1 from dataformat1 to dataformat2
( FIRST_NAME = FIRST_NAME,
LAST_NAME = LAST_NAME,
ADDRESS = ADDRESS,
ZIP = ZIP,
)
}
jobs
{
load1 load options ( parallel = "true" , truncate = "true", loadid = [myload1122]
(
source src1 target tgt1 map map1
source src2 target tgt1 map map1
source src3 target tgt1 map map1
)
)
(
<job-entry-list>
)
}
Examples
117