Hi Tina,
Tell you what..I faced the same problem and I got a workaround with it..what I did was take the result in an array and then assign a variable to the first element of the array in my loop.I am not aware about how effecient this is..but I'm still in the "If-it-wrks-it'll-do" phase in my MQSI career...:-)... > -----Original Message----- > From: Tina J.Kelly [SMTP:[EMAIL PROTECTED]] > Sent: Monday, June 24, 2002 4:48 PM > To: [EMAIL PROTECTED] > Subject: Retrieving a row of data from an external database? > > 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