HP Neoview Release 2.3 Software - Manual (Page 74)

Example A-1 Control File: Datatypes
/* All Data Types */
version 1;
options
{
errors = 1000,
discards = 500,
rowsetsize = 1000
}
typeformats
{
# comment: show examples of multiple date, time and interval formats
date_frmt date '%C%y-%m-%d'
time_frmt time '%H:%M:%s'
timestamp_frmt datetime '%C%y-%m-%d %H:%M:%s'
intv_frmt_00 interval '%Y'
intv_frmt_01 interval '%Y-%M'
intv_frmt_02 interval '%M'
intv_frmt_03 interval '%D'
intv_frmt_04 interval '%D:%H'
intv_frmt_05 interval '%D:%H:%M'
intv_frmt_06 interval '%D:%H:%M:%S'
intv_frmt_07 interval '%H'
intv_frmt_08 interval '%H:%M'
intv_frmt_09 interval '%H:%M:%S'
intv_frmt_10 interval '%M'
intv_frmt_11 interval '%M:%S'
intv_frmt_12 interval '%S'
}
# comment: use all the data types supported by Transporter
dataformats
{
# comment: dataformat for the input data file
dataformat1 delimited
records separated by <nl>
fields delimited by <,>
optionally qualified by <">
(
smin1 smallint,
smin2 smallint,
inte1 integer,
inte2 integer,
lint1 largeint,
nume1 numeric,
nume2 numeric,
deci1 decimal,
char1 char,
vchr1 varchar,
date1 date format date_frmt,
time1 time format time_frmt,
time2 time format time_frmt,
tims1 timestamp format timestamp_frmt,
tims2 timestamp format timestamp_frmt,
intv00 interval format intv_frmt_00,
intv01 interval format intv_frmt_01,
intv02 interval format intv_frmt_02,
intv03 interval format intv_frmt_03,
intv04 interval format intv_frmt_04,
intv05 interval format intv_frmt_05,
intv06 interval format intv_frmt_06,
intv07 interval format intv_frmt_07,
intv08 interval format intv_frmt_08,
intv09 interval format intv_frmt_09,
74 Control File Examples