| Author |
Message |
 Topic: IIB MQTT management interface |
paintpot
Replies: 2
Views: 2564
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 04, 2017 2:49 am Subject: IIB MQTT management interface |
Requires some heavy lifting to sift the output, but this command gives you the UUIDs (and a lot more)
mqsilist -a -r -d2 |
| Topic: Implementing Select Distinct or Group by in ESQL |
paintpot
Replies: 10
Views: 8963
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 21, 2017 5:19 am Subject: Implementing Select Distinct or Group by in ESQL |
Try using PASSTHRU for more complicated SQL:
"The main use of the PASSTHRU function is to issue complex SELECTs, not currently supported by the integration node, to databases. (Examples of com ... |
| Topic: ESQL Propogate issue |
paintpot
Replies: 5
Views: 3428
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 7:59 am Subject: ESQL Propogate issue |
Yep, I get the requirement.
Separate line of code
RETURN FALSE;
After your IF / ELSE |
| Topic: ESQL Propogate issue |
paintpot
Replies: 5
Views: 3428
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 7:32 am Subject: ESQL Propogate issue |
If I understand correctly, if the Data is null, you get a message out of 'out1' and then from 'out'?
Use RETURN FALSE; after you have propagated the messages that you need to. |
| Topic: Can we handle fields variation count using DFDL ??? |
paintpot
Replies: 30
Views: 11209
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 22, 2016 7:37 am Subject: Can we handle fields variation count using DFDL ??? |
As i said The Last Field may come (or) not and please find the difference below :
36 Fields
PI.HEADER:2000197067,20150619,3,NAZ,DNY,,20150619,,2000197067,218.85,000000000.00,218.85,000000000.00 ... |
| Topic: Can we handle fields variation count using DFDL ??? |
paintpot
Replies: 30
Views: 11209
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 22, 2016 7:31 am Subject: Can we handle fields variation count using DFDL ??? |
the comma is there - there are 3 in the first record (start at the start of the subset I copied), and 4 in the second version
How can you tell? How do you know that it's always the same field that ... |
| Topic: Can we handle fields variation count using DFDL ??? |
paintpot
Replies: 30
Views: 11209
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 22, 2016 7:04 am Subject: Can we handle fields variation count using DFDL ??? |
| the comma is there - there are 3 in the first record (start at the start of the subset I copied), and 4 in the second version |
| Topic: Can we handle fields variation count using DFDL ??? |
paintpot
Replies: 30
Views: 11209
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 22, 2016 6:39 am Subject: Can we handle fields variation count using DFDL ??? |
the optional field appears to be around 10 fields from the end of the record:
000000000.00,,,000000000.00,,.00,0.00,12.39,000000000.00,218.85,20150619,
vs.
000000000.00,,,,000000000.00,,.00,0.0 ... |
| Topic: Need return context info exception thrown from a collector n |
paintpot
Replies: 4
Views: 5267
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 16, 2016 3:38 am Subject: Need return context info exception thrown from a collector n |
Nice work.
Just to add to this, to add the value back it would be:
SET OutputLocalEnvironment.Destination.HTTP.RequestIdentifier = RequestId;
So modify the Output  |
| Topic: IIB 10 consideration over IIB 9 |
paintpot
Replies: 10
Views: 7587
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 10, 2016 4:10 am Subject: IIB 10 consideration over IIB 9 |
To be fair, IBM does publish clear information on their support policies online - google is a wonderful tool.
In general, they support n-2 versions, and provide support for a minimum of 5+3 years f ... |
| Topic: Next UK WebSphere Integration User Group meeting, PoCs +more |
paintpot
Replies: 1
Views: 1736
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 17, 2014 5:25 am Subject: Next UK WebSphere Integration User Group meeting, PoCs +more |
Just to highlight this event, in case you are like me and focus on the support pages rather than the news etc.
IBM Hursley, near Winchester, UK
1st July User Group
30th June / 2nd July PoTs ... |
| Topic: Next UK WebSphere Integration User Group meeting, PoCs +more |
paintpot
Replies: 0
Views: 2703
|
Forum: News/Updates Posted: Tue Jun 17, 2014 1:51 am Subject: Next UK WebSphere Integration User Group meeting, PoCs +more |
Just to highlight this event, in case you are like me and focus on the support pages rather than the news etc.
IBM Hursley, near Winchester, UK
1st July User Group
30th June / 2nd July PoTs
... |
| Topic: UK User Group Meeting & IBM MQ Conference July 1 2014 |
paintpot
Replies: 5
Views: 10550
|
Forum: News/Updates Posted: Tue Jun 17, 2014 1:44 am Subject: UK User Group Meeting & IBM MQ Conference July 1 2014 |
| Yes, that is correct - any combination of sessions can be attended. The voting via the checkbox is to help with seating/room allocation. |
| Topic: Subflows Vs Individual Mainflows (hops) |
paintpot
Replies: 11
Views: 6644
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 28, 2012 9:42 am Subject: Subflows Vs Individual Mainflows (hops) |
Best TPS is Approach 2.
YMMV - Your mileage may vary. Try it both ways and see.
Yep, absolutely. And don't forget the answer may change depending on what else you use this box for / how you have i ... |
| Topic: Subflows Vs Individual Mainflows (hops) |
paintpot
Replies: 11
Views: 6644
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 28, 2012 9:27 am Subject: Subflows Vs Individual Mainflows (hops) |
Transactionality? Is it valid to complete in multiple units of work?
Time to complete each 'chunk'. If any of the parts take a long time to complete, you will hold less resources / have better thro ... |
