| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| DATABASE SELECT ????? |
« View previous topic :: View next topic » |
| Author |
Message
|
| kiran26 |
 Posted: Wed Aug 21, 2002 12:38 pm Post subject: |
 |
|
Acolyte
Joined: 06 Feb 2002
Posts: 69
|
Hi,
Here is my esql,
SET Environment.Variables.Results[] = (SELECT T.NAME, T.CLASS,T.DESCRIPTION FROM Database.RULEPGM AS T WHERE T.RULEID='cld222');
---SET OutputRoot.XML.Framework.Person.(XML.Attribute)Name = Environment.Variables.Results[].NAME;
can u modify that and reply me back with how to loop into Result[]
Thanks
vishnu |
|
| Back to top |
|
 |
| abilott |
| Posted: Wed Aug 21, 2002 12:42 pm Post subject: Database Select |
|
|
Newbie
Joined: 21 Aug 2002
Posts: 3
|
| In further research, I'm trying to get the data back as a BLOB, the return limit seems to be 999 characters in length, although the data is complete in the database. How can I increase the size of the data I can get back? |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Aug 21, 2002 1:47 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
vishnu,
This is how you would assign data to XML elements.
| Code: |
set totalrecs = cardinality(Environment.Variables.Results[]);
set cnt = 1;
while (cnt <= totalrecs) do
SET OutputRoot.XML.Framework.Person[CNT].(XML.Attribute)Name = Environment.Variables.Results[CNT].NAME;
set cnt = cnt + 1;
end while;
|
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
