DSXchange

Hi,

I am trying to insert date values into db2 table
which is defined as date(10).

I tried using both ODBC & DB2UDB stage.


When i use ODBC stage, iam getting the following error:

Illegal date/time value DATE1 = '01/01/2004'

When i use DB2UDB stage, iam getting the following error:

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

I am using folowing code to convert into db2 format:

OCONV(ICONV(linkname.DATE1,"DMDY"),"D4/MDY[2,2,4]")

I tried inserting the Date value in all the possible DB2 formats,
by changing ICONV/OCONV formats,but no use.


Please help me out.

Hi,

You must output to the target database in DataStage internal format. For example, if your input date (Arg1) is in the format YYYYMMDD, then use the following in a routine:

Ans = Iconv(Arg1, "D-YMD[4,2,2]")

I am using folowing code to convert into db2 format:

OCONV(ICONV(linkname.DATE1,"DMDY"),"D4/MDY[2,2,4]")

I tried inserting the Date value in all the possible DB2 formats,
by changing ICONV/OCONV formats,but no use.

You could use the transform DateGenericToODBC to convert your date into an ODBC format or maybe use something similar to to this