| Author |
Message
|
| angka |
 Posted: Thu Mar 11, 2010 2:47 am Post subject: Pass in Integer to Oracle |
 |
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi,
There is a limitation that message broker can only pass in float to oracle. Is there a way that message broker can pass in integer instead? I need a very huge number and float not enough to support it. However i don't want to pass in as character. Any ideas?
Thanks |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Mar 11, 2010 3:17 am Post subject: Re: Pass in Integer to Oracle |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| angka wrote: |
| There is a limitation that message broker can only pass in float to oracle. |
Where do you find this documented? |
|
| Back to top |
|
|
| angka |
| Posted: Thu Mar 11, 2010 7:01 pm Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi,
I read it in the ESQL redbook v6r1 under "Data types of values from external sources" table. In the table esql integer is map to nothing for Oracle datatype
Thanks. |
|
| Back to top |
|
|
| harish_td |
| Posted: Thu Mar 11, 2010 7:14 pm Post subject: |
|
|
Master
Joined: 13 Feb 2006
Posts: 236
|
|
| Back to top |
|
|
| angka |
| Posted: Fri Mar 12, 2010 1:35 am Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi,
I tried passing in esql integer which is huge and the data in oracle DB is not correct. It shows negative value.
Thanks |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Mar 12, 2010 2:14 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| angka wrote: |
Hi,
I tried passing in esql integer which is huge and the data in oracle DB is not correct. It shows negative value.
Thanks |
Can you post the EQSL Integer you are using here?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Mar 12, 2010 6:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| angka wrote: |
I tried passing in esql integer which is huge and the data in oracle DB is not correct. It shows negative value.
|
Negative sounds like either the integer is smaller than the value you're passing or the endian is the other way round.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
