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
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am

Inserting decimal in Postgresql

Post by thurmy34 »

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 ( 1151)
at java.math.BigDecimal.charParser ( 816)
at java.math.BigDecimal.<init> ( 671)
at java.math.BigDecimal.<init> ( 650)
at ( 962)
at ( 679)

We triple checked that the data are really decimal.

Thank you.
Hope This Helps
Post Reply