Hi all,
I have setup a simple job for a staging area. This job reads some data from a source table in Oracle , add some fields, write data to a file and then it suppose to insert it in another table in Oracle. For Oracle connection I use ODBC.
The problem appeared from a field which is defined as NUMBER in Oracle and it has sometimes exponential values. The message from log is below:
abc1..ODBC_6.IDENT1.DSLink7: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO ORADEVSTAGE.ABC(DUNS_NUMBER) VALUES (?)
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client]Non-numeric data was found where numeric required
DUNS_NUMBER = 9.99E125
Any ideas how to handle this situation?
How to insert exponential numbers in Oracle?
Moderators: chulett, rschirm, roy
Hi,
The real qustion is how is the number suposed to be seen in the table?
if it is as with regular number you'll need to convert it, to the required format, or is the problem in the source data?.
is there any reason why you don't use the plugin stage to oracel?
IHTH,
The real qustion is how is the number suposed to be seen in the table?
if it is as with regular number you'll need to convert it, to the required format, or is the problem in the source data?.
is there any reason why you don't use the plugin stage to oracel?
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org