DB2 Timestamp Type Become Char Type
(Doc ID 2571133.1)
Last updated on AUGUST 14, 2019
Applies to:Oracle Database Gateway for DRDA - Version 126.96.36.199 and later
Information in this document applies to any platform.
Using Database Gateway for DRDA (DG4DRDA), you create a table from DB2 to Oracle via gateway.
create table <table_name> as select * from <db_table>@<dblink> WHERE 1=2;
The DB2 table contains columns of datatype TIMESTAMP. These are converted to CHAR in the new table in the Oracle DB
Why is this happening?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document