Memo from Tina J Kelly of PricewaterhouseCoopers
-------------------- Start of message text --------------------
Hi Suntosh,
What version of MQSI are you using? I'm using v2.0.2 and the compute node
on the advanced tab only has the options for Message, Exception or
Destination or a combination thereof?
Thanks,
Tina.
Suntosh Murthy <[EMAIL PROTECTED]>@AKH-WIEN.AC.AT> on 24/06/2002
14:31:00
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?
You can always use a PASSTHRU...
Set OutputLocalEnvironment.Tmp[] = PASSTHRU('Select F1, F2 From Table;');
Make sure your compute node on the Advanced tab has output as Local
Environment and Message. Depending on what DB you are using you may or may
not need the semi-colon.
Regards,
Suntosh
-----Original Message-----
From: Tina J.Kelly [mailto:[EMAIL PROTECTED]]
Sent: Mon 6/24/2002 9:04 AM
To: [EMAIL PROTECTED]
Cc:
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
"{-®孊뾊婶 x2¢륪)b
b²ٮnūb¢v«z?輧^v)톢ⳛ ®�ڕK ®nך½¨¥i¹^j
--------------------- 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.'rبfj*.f)+-r*'jub^.+-ޭTyڊV歆i0[(~(
܆+ކijHpq1'j!
