SET OutputRoot.XML.Message = THE(SELECT T.column1, T.column2 FROM
Database.table1 AS T);
Your values will be in OutputRoot.XML.Message.column1 and
OutputRoot.XML.Message.column2
Raul L. Acevedo
IT Architect
IBM Global Services
818-539-3203 Office (TL 396-3203) Glendale, CA
818-599-6626 Mobile
[EMAIL PROTECTED]
"Tina J.Kelly"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
GLOBAL.COM> cc:
Sent by: MQSeries Subject: Retrieving a row of data
from an external database?
List
<[EMAIL PROTECTED]
C.AT>
06/24/2002 07:18 AM
Please respond to
MQSeries List
Memo from Tina J Kelly of PricewaterhouseCoopers
-------------------- Start of message text --------------------
Hi!
I'm working with MQSI v2.0.2 and I'm trying to read several values from a
database and set a variable to the return.
In the manual it shows how to retrieve several values from a table,
SELECT T.column1, T.column2 FROM Database.table1 AS T
but it doesn't show how to set these values to a variable to use within my
control centre. I obviously can't set it to a string else I get the usual
'can't put list into non-list' error. I've tried using an array variable
e.g. Declare sArray[2] char; and setting this to the output from the
database lookup, I got some way with this, i.e. it deployed and executed
but it wasn't setting the variables within the array.
Do I need to use ROW and LIST constructors in an XML format?
I'm transforming an MRM input message into an output IDoc (NEON), if anyone
knows of any way to do this without using XML, I'd be really grateful to
hear from you.
Thanks very much,
Regards,
Tina.
--------------------- End of message text --------------------
This e-mail is sent by the above named in their
individual, non-business capacity and is not on
behalf of PricewaterhouseCoopers.
PricewaterhouseCoopers may monitor outgoing and incoming
e-mails and other telecommunications on its e-mail and
telecommunications systems.
_________________________________________________________________
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
