My Oracle Support Banner

DB2 Timestamp Type Become Char Type (Doc ID 2571133.1)

Last updated on AUGUST 14, 2019

Applies to:

Oracle Database Gateway for DRDA - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.