HP Neoview Release 2.5 Software - Manual (Page 96)

Example A-6 Control File: Include — Load From File to Table
/* Simple Load From File To Table Using INCLUDE To Include Control File Fragment (File 1/2) */
version 1.0;
# comment: control file fragment include_part_2.cf defines the data formats
%include "./CF/include_part_2.cf"
options
{
errors = 1000,
discards = 100,
rowsetsize = 5000
}
sources {
src1 file "./data_files/sn_nvt.dat"
tgt1 jdbc table NEO.nvt.sn_nvt 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
(
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 = "false" )
(
source src1 target tgt1 map map1
)
}
96 Control File Examples