| Author |
Message |
 Topic: DB statement issue |
koobz
Replies: 18
Views: 18028
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 28, 2014 6:02 am Subject: DB statement issue |
I didn't get much sleep either but I don't have the woozy head, so I expect your night was better than mine 
Set environmentVariable = passthru( select id from oracle sequence)
inse ... |
| Topic: DB statement issue |
koobz
Replies: 18
Views: 18028
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 28, 2014 5:11 am Subject: DB statement issue |
I've struggled with Oracle sequences also. Appreciate this is an old thread but as I am stuck with v6.1 due to a management decision, I'm hoping its appropriate to continue this one.
I've searched ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 27, 2013 9:19 am Subject: Coalesce function rounding error |
scrap that!
the old code was running under a different process...
apparently after deploying using the message broker toolkit GUI, it doesn't always remove the old dataflowengine process.
so a ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 27, 2013 8:52 am Subject: Coalesce function rounding error |
sent another 10 messages
10 rows appearing in the database, 2 with a rounding error:
transactionId RegularHrs
53073500005.000_4 1.95
53073500005.000_4 1.95
53073500005.000_4 ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 27, 2013 8:27 am Subject: Coalesce function rounding error |
Anyway I can get it to work by changing the code to use COALESCE(X,0.00)...
My mistake ... it works intermittently 
If I submit the same message 5 times using soapUI
<ns2:Transa ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 27, 2013 7:38 am Subject: Coalesce function rounding error |
Looks to me like you are using Coalesce without having defined the type of the variable you are assigning the result to before hand.
What is likely happening is that on the first iteration the coales ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 26, 2013 7:03 am Subject: Coalesce function rounding error |
the value for REGULARHRS in the last insert statement below, 1.49, gets rounded to 1.
... when viewed in the database |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 26, 2013 7:01 am Subject: Coalesce function rounding error |
What are the datatypes of these two fields in the DB? This can also have an effect?
What happens if you use a tool like db2cc, SQLServer Admin etc and manually issue the insert? using the values 1. ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 26, 2013 6:51 am Subject: Coalesce function rounding error |
OK - so I can't explain it but the MQ Trace looks fine. When I run the code using COALESCE (X, 0.00) it works fine - all values appear in the database (Oracle 10g) without rounding.
When I run the co ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 26, 2013 4:48 am Subject: Coalesce function rounding error |
| Vitor - appreciate that. If it was my choice we would get a more up to date version. Perhaps if I can prove this is a bug with this version I will have a little more ammo to persuade the organ grinder ... |
| Topic: Coalesce function rounding error |
koobz
Replies: 16
Views: 10967
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 26, 2013 3:50 am Subject: Coalesce function rounding error |
I'm having problems with the Coalesce function, which seems to be rounding down some decimals (Message Broker version is 6.0.0.5)
I have ESQL code that runs
WHILE LASTMOVE(inRef) DO
... |
