Control file: reflexive update, Control – HP Neoview Release 2.3 Software User Manual

Page 89

Text mode
Original mode

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