| Author |
Message
|
| kirran |
 Posted: Tue Mar 01, 2016 2:03 am Post subject: multiple records coding in esql |
 |
|
Novice
Joined: 29 Feb 2016
Posts: 18
|
| Iam getting 20 records from xml format from file input ,i want only 19 th record from that ,how to write esql code in compute node as xml format to put propagate to file output node. in wmb7 |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Mar 01, 2016 5:11 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
WMB7 is out of support. You really should move to a more recent version (IIB10)...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Mar 01, 2016 5:26 am Post subject: Re: multiple records coding in esql |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kirran wrote: |
| how to write esql code in compute node as xml format to put propagate to file output node. |
Same way you'd write any other ESQL code. What have you tried? What happened? What did you do to fix it?
Do you always want the 19th record or is it some arbitrary but calculatable number?
I echo the comment of my worthy associate. The ESQL would be the same, but you shouldn't be using an out of support version.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Mar 01, 2016 5:27 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| fjb_saper wrote: |
| WMB7 is out of support. You really should move to a more recent version (IIB10)... |
Of if the Web UI replacement for MBExplorer is a step too far then IIB V9 will do nicely.
As for your code, how do you think it could be done. Why not have a go and see what happens?
_________________
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 |
|
|
| kirran |
| Posted: Thu Mar 17, 2016 3:36 am Post subject: |
|
|
Novice
Joined: 29 Feb 2016
Posts: 18
|
| iam getting 10 records in xml format to compute node------then i want only 7 th record to be output.......by using esql code in compute node.........how can we write esql coding.............plz give coding for these......i used index based........ |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Thu Mar 17, 2016 4:20 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| kirran wrote: |
| how can we write esql coding |
Have you considered looking at the sample projects provided with the product? I recommend the Airline sample. It's got plenty of basic stuff.
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Mar 17, 2016 6:24 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| kirran |
| Posted: Sun Mar 20, 2016 11:23 pm Post subject: |
|
|
Novice
Joined: 29 Feb 2016
Posts: 18
|
This property controls whether the incoming message is received under sync point. Valid values are Automatic, Yes, and No.
If you select Automatic, the incoming message is received under sync point if it is marked persistent, otherwise it is not received under sync point. The transactionality of any derived messages that are sent later by an output node is determined by the incoming persistence property, unless the output node has overridden transactionality explicitly.
If you select Yes, the incoming message is received under sync point. Any derived messages that are sent later by an output node in the same instance of the message flow are sent transactionally, unless the output node has overridden transactionality explicitly.
If you select No, the incoming message is not received under sync point. Any derived messages that are sent later by an output node in the message flow are sent non-transactionally, unless the output node has specified that the messages must be put under sync point.
can u plzzz explain these. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Mar 21, 2016 12:27 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| kirran wrote: |
This property controls whether the incoming message is received under sync point. Valid values are Automatic, Yes, and No.
If you select Automatic, the incoming message is received under sync point if it is marked persistent, otherwise it is not received under sync point. The transactionality of any derived messages that are sent later by an output node is determined by the incoming persistence property, unless the output node has overridden transactionality explicitly.
If you select Yes, the incoming message is received under sync point. Any derived messages that are sent later by an output node in the same instance of the message flow are sent transactionally, unless the output node has overridden transactionality explicitly.
If you select No, the incoming message is not received under sync point. Any derived messages that are sent later by an output node in the message flow are sent non-transactionally, unless the output node has specified that the messages must be put under sync point.
can u plzzz explain these. |
This is the sort of questino that any decent IIB/Broker trainer would gladly answer as part of the training course.
Why don't you tell us what YOU understand by the statement you quoted?
Ok, we don't do 'text' speak here. u plzzz is Martian as far as I'm concerned.
_________________
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 |
|
|
| maurito |
| Posted: Mon Mar 21, 2016 1:20 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| kirran wrote: |
This property controls whether the incoming message is received under sync point. Valid values are Automatic, Yes, and No.
If you select Automatic, the incoming message is received under sync point if it is marked persistent, otherwise it is not received under sync point. The transactionality of any derived messages that are sent later by an output node is determined by the incoming persistence property, unless the output node has overridden transactionality explicitly.
If you select Yes, the incoming message is received under sync point. Any derived messages that are sent later by an output node in the same instance of the message flow are sent transactionally, unless the output node has overridden transactionality explicitly.
If you select No, the incoming message is not received under sync point. Any derived messages that are sent later by an output node in the message flow are sent non-transactionally, unless the output node has specified that the messages must be put under sync point.
can u plzzz explain these. |
Can you also explain how that relates to your original question ? |
|
| Back to top |
|
|
|
|
