MQSeries.net :: View topic

Kraven12 · Posted: Fri Nov 15, 2002 1:37 pm Post subject:

I am trying to retrieve a value from a UDB database using an inner join in the query. Because of the join, I am using Passthru.

Here is the code:

SET rgn_id = (PASSTHRU('SELECT R.RGN#ID
FROM F5977DB.TSCORG O INNER JOIN F977DB.TSCRGNDEF R ON O.PLCY#NBR = R.PLCY#NBR
WHERE O.ORG#NBR = ?
AND R.STTE#CDE = ?
AND ? BETWEEN R.RGNDEF#MIN_ZIP_NBR
AND R.RGNDEF#MAX_ZIP_NBR', InputRoot.MRM.ELIG_REC.ELIG_ORG_NBR, InputRoot.MRM.ELIG_REC.ELIG_STTE_CDE, InputRoot.MRM.ELIG_REC.ELIG_RES_ZIP_NBR));

When this is run I receive the following error:
"Trying to assign or use a list as a scalar"

I know this query returns only 1 result. I have tried using the "THE" keyword but it gets a syntax error.

Any ideas would be greatly appreciated.

Thanks in advance.