Memo from Tina J Kelly of PricewaterhouseCoopers -------------------- Start of message text --------------------
Hi Shiladitya, Could you possibly send a couple of lines of code to show how you did this. I've looked back at my notes and found that I couldn't create an array variable to accept the database lookup return. Declare sArray[2] char Set sArray[2] = SELECT T.column1, T.column2 FROM Database.table1 AS T This came back with the old can't put list into nonlist error. Were you using xml? Thanks for your help, Tina. "Ghosh, Shiladitya" <[EMAIL PROTECTED]>@AKH-WIEN.AC.AT> on 24/06/2002 13:06:11 Please respond to MQSeries List <[EMAIL PROTECTED]> Sent by: MQSeries List <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: Retrieving a row of data from an external database? 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 --------------------- 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