Control file: extract from neoview sql source – HP Neoview Release 2.5 Software User Manual
Page 89
Example A-2 Control File: Extract From Neoview SQL Source
/*----------------------------------------*/
/* Simple Extract From Neoview SQL Source To File */
/*----------------------------------------*/
version 1.0;
options
{
errors = 100,
discards = 100,
rowsetsize = 1000
}
dataformats
{
dataformat1 delimited
records separated by <nl>
fields delimited by <,>
optionally qualified by <">
(
SSN largeint,
FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
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 jdbc sql "select * from NEO.nvt.sn_nvt_ext order by SSN" options
(
system = "asl0101",
user = "user",
password = "transport",
datasource = "Admin_Load_DataSource",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/"
)
tgt1 file "./data_files/sn_ext.dat"
}
maps {
map1 from dataformat2 to dataformat1
(
SSN = SSN,
FIRST_NAME = FIRST_NAME,
89