Not able to insert records into Odbc enterprise stage target

[prasson_ibm]

Hi,
I have a job where i am extracting data from MSSQL server and target is Informix database. I am using ODBC connection for both source and target.

For SQL Server i am able to extract data into Datastage but while writing to ODBC Enterprise target i am getting below error message:-

Code: Select all

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.

Thanks
Prasoon

[chulett]

What are the datatypes in your Informix target? Sounds like at least one of them is of a type that is not supported.

[prasson_ibm]

Hi,

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.

[chulett]

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?

[prasson_ibm]

I have changed nchar to nvarchar...but still it is aborting with same error....

[chulett]

In the target metadata? Then I'm out of ideas... if no-one else comes along, I'd suggest taking this to your official support provider.

[prasson_ibm]

Yes in target metadata...i am also out of my mind.....

[prasson_ibm]

Hi All,

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).

Thanaks
Prasoon

[chulett]

Odd that something like that would cause such an error.

Glad you got it sorted out.