Inserting decimal in Postgresql

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am

Inserting decimal in Postgresql

Post by thurmy34 »

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


We triple checked that the data are really decimal.

Thank you.
Hope This Helps
Regards
Post Reply