DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Group memberships:
Premium Members

Joined: 31 Mar 2006
Posts: 197
Location: Paris
Points: 1512

Post Posted: Mon Aug 12, 2019 9:32 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
We can't insert values in decimal (numeric) columns in a postgresql database using datastage.
Via ODBC we have this error

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
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours