DSXchange

i am trying to load a csv file into a table ...

[DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field overflow.

i am getting the following error .... the date field is in M/DD/YYYY FORMAT AND the date format for oracle database is DD-MON-YY

... im just starting my first task in datastage so any help wuld be appreciated

Welcome aboard.

ODBC protocols require dates to be in YYYY-MM-DD format (according to the ISO 8601 standard). This requirement overrides the Oracle date picture and the actual format of your date.

Change your date format, for example using