DSXchange

Teradata API Stage - DLL teradata.so, Version 1.2.4.
DATE fields are ANSIDATE FORMAT yyyy-mm-dd.

We routinely change the Table definition metadata of any DATE field to CHAR(10) because this appears to be the only way to handle a date field via the Teradata API stage. Can be this true or are we missing something?
The teradata.pdf makes no mention of the DATE datatype being unsupported.
Is there some method that would preserve the metadata of the DATE field?

What data type do you get when you import the table definition from Teradata?

DATE!!! But no data pull is correct. It is as if DatgaStage converts it to an internal number but is using the wrong date format mask in doing so, therefore the OCONV back is not the correct date.

We have faced similar problem whilst reading from TD API stage with date as datatype works erratically, hence char(10) is the safest option.

The date in TD is internally stored as an integer so its o.k to use char(10) in the API stage to pull the data out.
P.S you can keep it as in the DS internal format. TD will convert it automatically when you insert it so no need of doing an oconv before