HP Neoview Release 2.5 Software - Manual (Page 113)

Example A-17 Control File: Simple Virtual Partitioned Load
/*---------------------------------------------------*/
/* Simple Virtual Partitioned load
/*---------------------------------------------------*/
version 1.0.0;
options
{
errors = 100
,discards = 100
,rowsetsize = 10
,commitsize = 20
,parallelstreams = 2
,system = "tra0101"
,user = "SUPERUSER"
,password = "HPNe@v1ew"
,datasource = "Admin_Load_DataSource"
,url = "jdbc:hpt4jdbc://tra0101.cup.hp.com:18650/"
}
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"
tgt1 jdbc table NEO.nvt.sn_nvt options
(
startpart = 1,
endpart = 8
)
tgt2 jdbc table NEO.nvt.sn_nvt options
(
startpart = 9,
# if endpart > max partitions, transporter will reset it to max partitions in the system
endpart = 1024
)
}
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
)
113