Hi Tina..
Declare sArray[] char;
Declare temp char;
WHILE
Set sArray[2] = SELECT T.column1, T.column2 FROM Database.table1 AS
T......
temp = sArray[0];
END WHILE;
Yes we were using XML...of course the limitation is that we need to
assign this temp to our OutputRoot before proceeding with the loop.Actually
what we needed was dynamic creation of tag names and this worked perfectly
fine.
Regards,
Adi
> -----Original Message-----
> From: Tina J.Kelly [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 6:35 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Retrieving a row of data from an external database?
>
> 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
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
