We can't insert values in decimal (numeric) columns in a postgresql database using datastage.
Via ODBC we have this error
Code: Select all
ODBC_NOMTABLE,0: ODBC function "SQLExecute" reported: SQLSTATE = 22018: Native Error Code = 0: Msg = [IBM (DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver]Invalid character value. Error in parameter 62. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 731)
Via JDBC this one
JDBC_Connector_13,0: java.lang.NumberFormatException: Infinite or NaN
at java.math.BigDecimal.bad (BigDecimal.java: 1151)
at java.math.BigDecimal.charParser (BigDecimal.java: 816)
at java.math.BigDecimal.<init> (BigDecimal.java: 671)
at java.math.BigDecimal.<init> (BigDecimal.java: 650)
at com.ibm.is.cc.jdbc.CC_JDBCBigBufferRecordDataSetConsumer.initializeStatementParameters (CC_JDBCBigBufferRecordDataSetConsumer.java: 962)
at com.ibm.is.cc.jdbc.CC_JDBCBigBufferRecordDataSetConsumer.consumeBigBuffer (CC_JDBCBigBufferRecordDataSetConsumer.java: 679)
Thank you.