How to process timestamp with timezone in teradata connector

[arvind_ds]

Hi DS experts,

Our requirement is to process data by using teradata connector stage in datastage 8.7 version. We want to process data of type "TIMESTAMP WITH TIME ZONE".We are using Teradata as source/target database.

But it is specified in documentation(IBM InfoSphere Information Server, Version 8.7) that :

The Teradata connector supports most Teradata data types except INTERVAL, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, and UDT.

http://pic.dhe.ibm.com/infocenter/iisin ... types.html

Please share your opinion on how to achieve this requirement in datastage.[/b]

[ray.wurlod]

If it's a source use custom (user-defined) SELECT statement to CAST the column(s) as TIMESTAMP. Or use the appropriate SQL function to achieve that conversion.

Similarly, when addressing the target, use the appropriate conversion function in user-defined INSERT or UPDATE statements.