Please, Ask me the answer which data type of wrapper on DB2 II.
I tested wrapper on DB2 II.
I want to know the data type I can data type of wrapper.
I failed to test which there was contained integer, dec(15,0), varchar().
It's my test script.
===========================================================
create wrapper flat_wrap library 'libdb2lsfile.a';
create server flat_svr wrapper flat_wrap;
create nickname i_cimcadr (
cust_id varchar(13),
addr_code varchar(1) ,
tel_no1 varchar(4) ,
tel_no2 varchar(4) ,
tel_no3 varchar(4) ,
regi_dt varchar(8) ,
updt_dt varchar(8) ,
proc_empl_no varchar(8) ,
pro_tax dec(15,0) ,
land_tax dec(15,0) ,
land_cnt integer
)
for server flat_svr
options ( file_path '/home/db2inst1/test.dat',
column_delimiter '!',
sorted 'N' ) ;
===========================================================
I failed test. But, I converted dec(15,0) to varchar(15) and integer to varchar(5), so I success.
However, when I test query, I must to convert at reverse.
Please, Ask me the answer which data type of wrapper on DB2 II.
I tested wrapper on DB2 II.
I want to know the data type I can data type of wrapper.
I failed to test which there was contained integer, dec(15,0), varchar().
It's my test script.
===========================================================
create wrapper flat_wrap library 'libdb2lsfile.a';
create server flat_svr wrapper flat_wrap;
create nickname i_cimcadr (
cust_id varchar(13),
addr_code varchar(1) ,
tel_no1 varchar(4) ,
tel_no2 varchar(4) ,
tel_no3 varchar(4) ,
regi_dt varchar(8) ,
updt_dt varchar(8) ,
proc_empl_no varchar(8) ,
pro_tax dec(15,0) ,
land_tax dec(15,0) ,
land_cnt integer
)
for server flat_svr
options ( file_path '/home/db2inst1/test.dat',
column_delimiter '!',
sorted 'N' ) ;
===========================================================
I failed test. But, I converted dec(15,0) to varchar(15) and integer to varchar(5), so I success.
However, when I test query, I must to convert at reverse.
Please, Ask me the answer which data type of wrapper on DB2 II.