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



Group memberships:
Premium Members

Joined: 31 Mar 2006
Posts: 189
Location: Paris
Points: 1440

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

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

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