Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data type of wrapper on DB2 II

Status
Not open for further replies.

shim21c

Technical User
Sep 18, 2003
4
KR
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top