HP Neoview Release 2.3 Software - Manual (Page 95)

Example A-14 Control File: Forcestaging Load with Multiple Job Entries in a Single Job
/*-------------------------------------------------------------------------------------*/
/* A Single Load Job Using Staging Tables And Multiple Job Entries Running In Parallel */
/*-------------------------------------------------------------------------------------*/
version 1;
options
{
errors = 1000,
discards = 100,
rowsetsize = 5000,
forcestaging = "true",
sorted = "true"
}
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
)
}
sources {
src1 file "./data_files/sn_nvt_01.dat"
src2 file "./data_files/sn_nvt_02.dat"
src3 file "./data_files/sn_nvt_03.dat"
tgt1 jdbc table NEO.nvt.sn_nvt options
(
system = "asl0101",
user = "gcscsup",
password = "transport",
datasource = "TDM_Default_DataSource",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/",
)
}
maps {
map1 from dataformat1 to dataformat2
(
FIRST_NAME = FIRST_NAME,
LAST_NAME = LAST_NAME,
ADDRESS = ADDRESS,
ZIP = ZIP,
PHONE = PHONE,
SSN = SSN,
INFO1 = INFO1,
INFO2 = INFO2
)
}
jobs
{
load1 load options ( parallel = "true" )
(
source src1 target tgt1 map map1
95