Posted: Wed May 15, 2002 3:58 am Post subject: WMQI Compute Node - ODBC errors for some SQL statements
Newbie
Joined: 14 May 2002 Posts: 1 Location: UK
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.
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
Could you post ExceptionList here? It will tell you exactly which function is failing (not supported). _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum