| Author |
Message
|
| cyclekumar |
 Posted: Sun Feb 28, 2010 9:19 am Post subject: WMB v6 ESQL array data type |
 |
|
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 |
|
 |
| smdavies99 |
| Posted: Sun Feb 28, 2010 9:46 am Post subject: |
|
|
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 |
|
|
| cyclekumar |
| Posted: Sun Feb 28, 2010 10:03 am Post subject: |
|
|
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 |
|
|
| smdavies99 |
| Posted: Sun Feb 28, 2010 12:38 pm Post subject: |
|
|
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 |
|
|
|
|
