MQSeries.net :: View topic - WMQI Compute Node

ievans · Posted: Wed May 15, 2002 5:49 pm Post subject:

WMQI v2.1 CSD02

iSeries V5R1

I am using a compute node to build an XML document.

Requirement:
I need to access the database to return a mix of single and multiple rows, based on selections defined in other variables. Eg.

SET "OutputRoot"."MRM"."SODetail"."ItemIdentifier"[] = THE (SELECT ITEM T.ITEMID FROM Database.TESTLIB.TRANS AS T where T.MSGREF = CAST("InputBody"."OrderNumber" as DECIMAL(15,0));

Issues
If I use the Client Access ODBC Driver then it works providing that I only want to access single records.

However, as soon as I request multiple records to be processed the broker appears to loop consuming machine resources and I am forced to end the broker abnormally.

On the other hand if I use the IBM DB2 driver then I get an error message if I try to use a variable in the select statement. {Hard coding the where clause to a specific reference successfully builds the record set}

Messages returned are
BIP2519 stating the SQL statement that failed.
BIP2321 Database error ODBC return code = -1
BIP2322 Database error SQL State 'IM001'; SQL Native Error Code '0'; Error text 'Microsoft ODBC Driver Manager Driver does not support this function.

Any ideas?