Control file: load fixed width data – HP Neoview Release 2.4 Software User Manual

Page 87

Text mode
Original mode

Example A-4 Control File: Load Fixed Width Data

/* Load Fixed Width Data */

version 1;

options
{
errors = 1000,
discards = 100,
rowsetsize = 5000
}

dataformats
{

# fixed width data source file
dataformat1 fixed
record length 443
fields positions
(
1,
13,
37,
165,
169,
179,
187,
315
)
(
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_fw.dat"

tgt1 jdbc table NEO.nvt.sn_nvt options
(
system = "asl0101",
user = "user",
password = "transport",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/",
datasource = "Admin_Load_DataSource"
)
}

maps {
map1 from dataformat1 to dataformat2
(
FIRST_NAME = FIRST_NAME,