Control file: include — load from file to table – HP Neoview Release 2.3 Software User Manual

Page 84

Text mode
Original mode

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

Control File Examples