DSXchange

Hi:

I have a problem with Informix native connection when I use DATE data type. Currently I am using Informix ODBC connection and it work fine with DATE columns, but I know that native connection is better than ODBC connection so I would like to use native connection. The problem is when I use Informix-CLI stage, the datastage shows the following message:

"pruebaSote..Informix_CLI_6.IDENT1: At row 1, link "DSLink2", while processing column "fec_finvig"
Value treated as NULL Attempt to convert String value "07/01/2005" to Date type unsuccessful"

Thanks for your help.

Victor.

Welcome aboard! :D

Since the problem is in row #1, does the file have column headings but you forgot to check this box in the Sequential File stage Format tab?

Otherwise, what is the actual value in the fec_finvig column being sent to the Informix table? You can use the Debugger or stage tracing to determine this. Is it, in fact, a date? If so, does its format conform to the date format required by your Informix database?

The error is not thrown by the database but is done by DataStage.

If you reading from the db, check whether you are converting it into a string inside the cli.

If it is in a trans stage, use IConv.