| Author |
Message |
 Topic: ROUND in ESQL not working as expected |
Adi3
Replies: 9
Views: 10035
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 21, 2007 10:52 am Subject: ROUND in ESQL not working as expected |
It works fine with the MB runtime fixpack3 and MB tool kit interim fix008.
Thank you. |
| Topic: ROUND in ESQL not working as expected |
Adi3
Replies: 9
Views: 10035
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 20, 2007 8:20 am Subject: ROUND in ESQL not working as expected |
Even If I select the mode from the drop down list, it says as follows:
Severity Description Resource In Folder Location Creation Time
2 Syntax error. Valid options include: ROUND_CELLING ROUND_DOW ... |
| Topic: ROUND in ESQL not working as expected |
Adi3
Replies: 9
Views: 10035
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 20, 2007 6:33 am Subject: ROUND in ESQL not working as expected |
By seeing the example and table in the Information Center. I replied that ROUND_HALF_UP is working.
The list of modes given for Round are:
ROUND_UP
ROUND_DOWN
ROUND_CEILING
ROUND_FLOOR
ROUND_H ... |
| Topic: ROUND in ESQL not working as expected |
Adi3
Replies: 9
Views: 10035
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Aug 18, 2007 10:08 am Subject: ROUND in ESQL not working as expected |
Jeff, Thanks a lot!
I referred the ESQL manual but not the Information center. Here after, I will refer the Information center too. Its working as expected with the mode ROUND_HALF_UP. |
| Topic: ROUND in ESQL not working as expected |
Adi3
Replies: 9
Views: 10035
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 17, 2007 6:45 pm Subject: ROUND not working as expected |
| I referred the ESQL Document and found nothing relevant that is the reason I posted here to get masters help |
| Topic: ROUND in ESQL not working as expected |
Adi3
Replies: 9
Views: 10035
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 17, 2007 12:37 pm Subject: ROUND in ESQL not working as expected |
ROUND(1.9150)
Returns 1.92
which is correct
But
ROUND(1.9450)
Returns 1.94 (weird behaviour of esql function)
which is incorrect, the result should be as 1.95
I need this Round logic to ... |
| Topic: Trim to required length in CWF Message Set |
Adi3
Replies: 1
Views: 2023
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed May 16, 2007 12:33 pm Subject: Trim to required length in CWF Message Set |
Is there any option to trim for required length in CWF Message Set.
For eg:
There is a field called "Name" in Output MRM (CWF format):
Name Length(15) String
In esql: ... |
| Topic: Different Message Sets with single Input node |
Adi3
Replies: 2
Views: 2175
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 20, 2007 5:55 pm Subject: Different Message Sets with single Input node |
I need to route the 20 different CWF messages(each defined as different MRMs) to the destination list.
I'm ok with the Routing logic (based on content routing with database to destinationlist - com ... |
| Topic: Queues under Execution Group |
Adi3
Replies: 8
Views: 3819
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 12, 2007 1:05 pm Subject: Queues under Execution Group |
I have set of message flows under execution group 'Test'. I created a new flow with input q 'IN' and deployed under the same.
When I tried to test the new flow by placing a message in q 'IN', I fou ... |
| Topic: Write ESQL code to extract data from the DB and merge it |
Adi3
Replies: 10
Views: 7445
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Dec 26, 2006 7:04 am Subject: Write ESQL code to extract data from the DB and merge it |
<test><data>data from input</data></test><test><data>data from database</data></test>
The expecting result is an invalid XML.
Root tag <test ... |
| Topic: CodedCharSetId Values |
Adi3
Replies: 13
Views: 20878
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Dec 22, 2006 8:49 am Subject: CodedCharSetId Values |
| Thank you very much wschutz, This is what I was expecting and atlast I got it. |
| Topic: CodedCharSetId Values |
Adi3
Replies: 13
Views: 20878
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 20, 2006 12:45 pm Subject: CodedCharSetId Values |
Thanks for your answer.
Actually my question is different.
"You should only ever set the CCSID to the one that is appropriate for the data that you have put into the message."
Yes i ... |
| Topic: CodedCharSetId Values |
Adi3
Replies: 13
Views: 20878
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 20, 2006 11:52 am Subject: CodedCharSetId Values |
In ESQL program I have the following line:
SET OutputRoot.MQMD.CodedCharSetId = 37;
I would like to know for which system this Id is mentioned.
By seeing the value, I would like to know the t ... |
| Topic: CodedCharSetId Values |
Adi3
Replies: 13
Views: 20878
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 20, 2006 9:40 am Subject: CodedCharSetId Values |
Where can I get the details and list of CodedCharSetId?
For eg:
Which CodedCharSetId I should use for different applications like Mainframe, Solaris etc. |
| Topic: Message Routing |
Adi3
Replies: 1
Views: 1875
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Dec 19, 2006 8:14 am Subject: Message Routing |
We are planning to create a Message Routing Engine which routes the message to one or many destinations.
There is a way to accomplish this using database and cache.
For other options:
Is it a g ... |
