HP Neoview Release 2.3 Software - Manual (Page 93)

Example A-12 Control File: Usage of NULLSTRING
/*--------------------------------*/
/* Usage of NULLSTRING */
/*--------------------------------*/
version 1.0;
options
{
errors = 1000
,rowset = 5000
,nullstring = "^"
}
dataformats
{
dataformat1 delimited
records separated by
fields delimited by <,>
optionally qualified by <">
( FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
SSN int,
INFO1 char,
INFO2 char
)
dataformat2 sql fields
( FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
SSN int,
INFO1 char,
INFO2 char
)
}
sources {
src1 file "./data_files/sn_nvt_nls.dat"
tgt1 jdbc table NEO.nvt.sn_nvt_nls options
(
system = "asl0101",
user = "gcscsup",
password = "transport",
datasource = "TDM_Default_DataSource",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/"
)
}
93