ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB v6 ESQL array data type

Post new topic  Reply to topic
 WMB v6 ESQL array data type « View previous topic :: View next topic » 
Author Message
cyclekumar
PostPosted: Sun Feb 28, 2010 9:19 am    Post subject: WMB v6 ESQL array data type Reply with quote

Newbie

Joined: 28 Feb 2010
Posts: 6
Hi,

Hope this is right section to raise this problem...
i am working on wepshere MQ v6.0.. just want to know whether in eqsl is there any data type which holds list/array of similar items. Like array of strings. Below is the exact scenario which i need to handle while processing response flow.

i have two message sets one is for application side which is fixed length string format( CWF) and other one is for third party side which is xml.
i will get a xml response from third party which has repeatable block within particular node. All i need is while processing the repeatable block i want to store this value in array, so that whenever i populate the response for application side i will refer value from this array.

Right now i am using plain string variable to append each repeatable node value from xml with delimiter, but this approach is painful as we need to do so much of string manipulation..........

or should i use environment variable as array ?
Not sure which is the right way to do.....

Plz let me know how to handle this scenario.

Thanks in advance...

- Skumar
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sun Feb 28, 2010 9:46 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
There is lots of wonderful information in the Info Centre. I just did a search for

ESQL Array

and everything I would need appeared as if by magic. Especially usesful is the topic about working with known multiple elements.

Take a look see and come back to us with any further questions.
_________________
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
View user's profile Send private message
cyclekumar
PostPosted: Sun Feb 28, 2010 10:03 am    Post subject: Reply with quote

Newbie

Joined: 28 Feb 2010
Posts: 6
Thanks for your response.

Even i did search for esql array but that is not the one i am looking for

But my question was is there any way to declare one esql variable as array type... like below

DECLARE stringVariable CHARACTER[];
stingVariable[0] = OutputRoot.XML.BODY.Department[0].name
stringVariable[1] = OutputRoot.XML.BODY.Department[1].name

so that i can use stringVariable in later point to populate my actual response back to the appllication.

Thanks
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sun Feb 28, 2010 12:38 pm    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
Look at the SELECT verb

In ESQL Selects are not just from DB tables.

Then use the CARDINALITY function to determine the number of elements in the list.
_________________
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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB v6 ESQL array data type
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.