Problem with Informix Native Connection

[vhuaquis]

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.

[ray.wurlod]

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?

[Sainath.Srinivasan]

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.