I'm having troubles to operate an ETL process on DataStage. I have the following error log:
#TABLE#,0: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = -332: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]TRANSLATION FROM CCSID 13488 TO 65535 NOT DEFINED. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 812)
For what I've understood from the error and some internet sources, the problem is I am reading the date with Unicode and the target table while, on the other hand, it needs to have an *HEX coding.
I can't access to AS400, so I am wondering if it exists a way to cast this problem from the ETL (DataStage) tool.