MQSeries.net :: View topic

GoodBoy · Posted: Thu Apr 08, 2004 11:26 pm Post subject:

Hi All,

Can anyone help me with using PASSTHRU to my situation.

My original query to a database under schema abcd45 is :

select DISTINCT MAX(Pid) from abcd45.table5;
Returns : 3

This works fine at SQL prompt.

I was implementing it in Database node as follows:

DECLARE schema1 CHAR;
DECLARE temp INT;
SET schema1 = 'abcd45';

SET temp = PASSTHRU ('SELECT DISTINCT MAX(E1.Pid) FROM ' || schema1 ||'.table5 E1');

SET Environment.variable.temp555 = temp;

------------------------------

And I am trying to see the value of temp555 in the trace file. By setting
Pattern to : ${Environment.variable.temp555}
---------------------------------------------------------

The Query is working and it is ubable to assign the result (in this example 3 an integer value) to temp. saying
'Trying to assign or use a list as a scalar'
-----------------------------------------------------

How can I accommodate 'THE' in the PASSTHRU to change resulting 'list' from select statement to a 'scalar' value . In my case the result is list of single value 3.

Pl halp me in fixing this.

GoodBoy