| Author |
Message
|
| akm.murthy |
 Posted: Thu Mar 31, 2016 2:39 am Post subject: I need esql code for below logic |
 |
|
Newbie
Joined: 31 Mar 2016
Posts: 1
|
select blobData as count from AIP_INTG_AB where UKID = $SourceID and transactionapp = SubscriptionIdentifier.
Count = 0
Insert record to AIP_INTG_AB with UKID= $SourceID, BlobData= convertoHex(inputpayload), transactionapp='UPS'
else
compare blobData with input message
if equal then ignore by doing audit log entry as complete and audit log message duplicate entry found.
Otherwise
Update the entry in AIP_INTG_AB with new input message and current lastchange date.
Send data to Outbound queue. |
|
| Back to top |
|
 |
| exerk |
| Posted: Thu Mar 31, 2016 2:48 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
And this relates to what? You're clearly not posting a link, so which forum do you wish this to be moved to?
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 31, 2016 4:10 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Moved to broker forum 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Mar 31, 2016 4:45 am Post subject: Re: I need esql code for below logic |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| akm.murthy wrote: |
select blobData as count from AIP_INTG_AB where UKID = $SourceID and transactionapp = SubscriptionIdentifier.
Count = 0
Insert record to AIP_INTG_AB with UKID= $SourceID, BlobData= convertoHex(inputpayload), transactionapp='UPS'
else
compare blobData with input message
if equal then ignore by doing audit log entry as complete and audit log message duplicate entry found.
Otherwise
Update the entry in AIP_INTG_AB with new input message and current lastchange date.
Send data to Outbound queue. |
And what exactly is preventing you from getting ESQL code for this logic? Apart from the part where you're sending data to an outbound queue, which obviously can't be done directly from ESQL>
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Mar 31, 2016 5:08 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
This
| Code: |
select blobData as count
|
Would return an Integer
so how can you
| Code: |
compare blobData with input message
|
Care to explain?
_________________
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: Thu Mar 31, 2016 7:37 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| smdavies99 wrote: |
This
| Code: |
select blobData as count
|
Would return an Integer
|
Why an integer ?, very likely it will not. First of all, the OP has not said whether the SELECT is an IIB select or a PASSTHRU to the db. |
|
| Back to top |
|
|
| timber |
| Posted: Fri Apr 01, 2016 8:41 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| @akm.murthy: Please explain your scenario more carefully. We are confused. |
|
| Back to top |
|
|
|
|
