Insert into AS400 using ODBC
Posted: Fri Jan 13, 2012 3:48 am
Hi All,
We are using 8.5.0.1 on AIX 6.1,
I have a problem while inserting Varchar Data to AS400 Side.
AS400 tables are available and opened joulnal preferences, Moreover, I could insert Data with dssh and DS_CONNECT command.
I set Isolation Level to 32 however it makes no sense.
My Job Design like this,
RowGen---->ODBC Connector and I pasted below the error Code, Hance column defined VARCHAR, I am sure.
--
ODBC_Connector_12: Schema reconciliation detected a type mismatch for field DM_BOOKMARK. When moving data from field type VARCHAR(min=0,max=1024) into BINARY(min=0,max=1024), data corruption can occur (CC_DBSchemaRules::reportTypeMismatch, file CC_DBSchemaRules.cpp, line 1,719)
--
Thanks for all ideas,
Oğuz.
We are using 8.5.0.1 on AIX 6.1,
I have a problem while inserting Varchar Data to AS400 Side.
AS400 tables are available and opened joulnal preferences, Moreover, I could insert Data with dssh and DS_CONNECT command.
I set Isolation Level to 32 however it makes no sense.
My Job Design like this,
RowGen---->ODBC Connector and I pasted below the error Code, Hance column defined VARCHAR, I am sure.
--
ODBC_Connector_12: Schema reconciliation detected a type mismatch for field DM_BOOKMARK. When moving data from field type VARCHAR(min=0,max=1024) into BINARY(min=0,max=1024), data corruption can occur (CC_DBSchemaRules::reportTypeMismatch, file CC_DBSchemaRules.cpp, line 1,719)
--
Thanks for all ideas,
Oğuz.