ODBC_Enterprise_36,2: [IBM(DataDirect OEM)][ODBC Informix Wire Protocol driver]This is either an Unknown Type or is not supported currently. Error in parameter 1.
ODBC_Enterprise_36,2: The runLocally() of the operator failed.
I am not able to understand what exactly is the issue.
Need help in resolving this problem.
We have only four columns in target infomix database with two different datatypes.
Col1 Char Unicode 4 nullable
Col2 Char Unicode 1 nullable
Col3 date 10 nullabe
Col4 Char unicode 2000 nullable --- This column has the value of 50 source columns concatinated with pipe.
Hmmm... while Informix supports CHAR fields up to 32,767 in length, I don't believe ODBC does. What happens if you declare it as a VARCHAR (or NVARCHAR) in the job?
-craig
"You can never have too many knives" -- Logan Nine Fingers
I am able to insert records.That error was coming because in one source column there was new line character was there. So i removed new line charcter by writing function convert(char(10),"",input.col).