DSXchange

Hi,

I have a input sequential file with a field value '2010-05-16'. Need to convert this into Date & load it into a Teradata table.

Based on Dsxchange suggestions, I tried different combinations of oconv & iconv. But it doesn't work.

The error says:

Value treated as NULL
Attempt to convert String value "" to Date type unsuccessful

Please help !!

Thanks,
dxk9

you need to use as shown

What is your default date format for Teradata? (You may need to ask your DBA.)

Zulfi,

Thanks !! Your suggestion worked

Ray,

As of now its working, will also know the Teradata default date format from DBAs for future reference.

Thanks,
dxk9

So Teradata needs the date in internal format? Don't recall hearing that before. Have you verified that you get the correct date in the database rather than it works because the job no longer throws the error?

I would expect a server job to behave this way. One exception is ODBC, where you have to specify this behaviour by specifying Date as the data element.

Sorry for being especially dense tonight but why would you 'expect a Server job to behave this way'? I must be missing something fundamental here...

Because, in server jobs, the representation of the Date data type is "internal format". Most Connectors (and their predecessors) perform the conversion automatically where the metadata are consistent.

Ah... having dealt basically 100% with Oracle where I would always treat a DATE as a full Timestamp with explicit control over the time portion, that never really clicked for me.

Oracle is ...
_________________ ... different