Control file: reflexive update, Control – HP Neoview Release 2.5 Software User Manual
Page 101
Example A-9 Control File: Reflexive Update
/*-------------------------*/
/* Simple Reflexive Update */
/*-------------------------*/
version 1.0;
options
{
errors = 1000,
discards = 100,
rowsetsize = 100
}
dataformats
{
dataformat1 delimited
records separated by <nl>
fields delimited by <,>
optionally qualified by <">
(
C1 int,
C2 int,
C3 char
)
dataformat2 sql fields
(
C1 int,
C2 int,
C3 char
)
}
sources {
src1 file "./data_files/sn_nvt_refu.dat"
tgt1 jdbc table NEO.nvt.sn_nvt_refu options
(
system = "asl0101",
user = "user",
password = "transport",
datasource = "Admin_Load_DataSource",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/"
)
}
maps {
map1 from dataformat1 to dataformat2
(
C1 = C1,
C2 = C2 add,
C3 = C3
)
}
jobs
{
load1 load options ( parallel = "true" )
(
source src1 target tgt1 map map1
)
}
101