HP Neoview Release 2.3 Software User Manual

Page 75

intv10 interval format intv_frmt_10,
intv11 interval format intv_frmt_11,
intv12 interval format intv_frmt_12,
flot1 float,
flot2 float
)

# comment: data format for the target SQL table on the Neoview platform */
dataformat2 sql fields
(
smin1 smallint,
smin2 smallint,
inte1 integer,
inte2 integer,
lint1 largeint,
nume1 numeric,
nume2 numeric,
deci1 decimal,
char1 char,
vchr1 varchar,
date1 date,
time1 time,
time2 time,
tims1 timestamp,
tims2 timestamp,
intv00 interval,
intv02 interval,
intv03 interval,
intv05 interval,
intv07 interval,
intv08 interval,
intv09 interval,
intv10 interval,
intv12 interval,
intv13 interval,
intv14 interval,
intv16 interval,
intv17 interval,
flot1 float,
flot2 float
)
}

sources {
src01 file "./data_files/sn_nvt_all_typ.dat"

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

maps {
map01 from dataformat1 to dataformat2
(
smin1 = smin1,
smin2 = smin2,
inte1 = inte1,
inte2 = inte2,
lint1 = lint1,
nume1 = nume1,
nume2 = nume2,
deci1 = deci1,
char1 = char1,
vchr1 = vchr1,
date1 = date1,
time1 = time1,
time2 = time2,