MQSeries.net :: View topic - Swift with select statement

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Swift with select statement

Swift with select statement

« View previous topic :: View next topic »

Author

Message

dinu7102

Posted: Mon Jun 26, 2017 3:30 am Post subject: Swift with select statement

Newbie

Joined: 14 May 2017
Posts: 8

INPUT :

Code:

MT543
A
SM20C
SM15B
SM19D
B
SW98A--> Q->X
D ->20
SW98A-->Q ->Y
D->30
C
SW23G
SM89F
D
SW98F
SW64A

I need output when the condition Q=Y in SW98A mean i need D=30 as output

I used select statement

Code:

SET ENVORIMENT.DATA = THE('SELECT T.D FROM INputroot.MRM.TEXTBLOCK.MT543.*[] as T WHERE T.SW98A.Q ='Y');

WHY i used *[] because for the other message this value SW98A may come D or C or A.
Now in environment nthg is coming

Can anyone help on this.

mqjeff

Posted: Mon Jun 26, 2017 4:02 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Well. First, you're using MRM. That's bad.

Second, you might check whether you need an "=" or an "==" or etc.

Third, the structure of your model is very unclear. Perhaps you tried to use spaces to indent and then didn't put it inside a [ c o d e ] block.
_________________
chmod -R ugo-wx /

dinu7102

Posted: Mon Jun 26, 2017 4:28 am Post subject:

Newbie

Joined: 14 May 2017
Posts: 8

MT543
A
SM20CÂ
SM15BÂ
SM19DÂ
B
SW98A
Q X
D 20
SW98A
Q Y
D 30
C
SW23GÂ
SM89FÂ
DÂ
SW98FÂ
SW64A

Its already existing interface.
If i am sending single segment its working but try for mutiple its not working.see the structure which is working.
Working Structure :
MT543
A
SM20CÂ
SM15BÂ
SM19DÂ
B
SW98A
Q Y
D 30
C
SW23GÂ
SM89FÂ
DÂ
SW98FÂ
SW64A

mqjeff

Posted: Mon Jun 26, 2017 4:44 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Again. I can't tell what fields are children of what fields. You must wrap your data in [ c o d e ] blocks if you want to use spaces or other indents.

And again. MRM is bad.

Even if it's working.

Also, you haven't mentioned what version of IIB you are using. If you are using anything lower than v9, you should strongly consider finding another client or job.
_________________
chmod -R ugo-wx /

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Swift with select statement

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP