MQSeries.net :: View topic - stored procedure

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » stored procedure

stored procedure

« View previous topic :: View next topic »

Author

Message

paustin_ours

Posted: Tue Mar 14, 2006 1:20 pm Post subject: stored procedure

Yatiri

Joined: 19 May 2004
Posts: 667
Location: columbus,oh

i am trying to invoke a db2 stored procedure on a zos db2 subsystem. the stored procedure doesnt not have any input parameters. this is more like a test SP.

i have

COMPUTE MODULE

call PROC1()

END

CREATE PROCEDURE PROC1() EXTERNAL NAME GGG.PROC;

The SP works fine from a COBOL program.

i get the following error

BIP2921E F9DCBRK default 41 THE PROCEDURE 'GGG.PROC' WITH '0' PARAMET
ERS COULD NOT BE MATCHED WITH A CORRESPONDING DATABASE STORED PROCEDUR
E. : ImbRdlRoutine(1136)

any thoughts? not sure as to what i am missing.

mgk

Posted: Tue Mar 14, 2006 3:47 pm Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

Hi,

As the error says, the broker cannot find the procedure in the DB. Are you sure you have the authority to see it from the brokers userid? Are you sure it lives in schema GGG?

Regards.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

Posted: Tue Mar 14, 2006 4:12 pm Post subject:

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

Quote:

....the stored procedure doesnt not have any input parameters.

.......if that's true, then is it exporting an output parameter?

Quote:

BIP2921 Explanation
Stored Procedures must match the ESQL CREATE PROCEDURE definition in the following ways: 1: The ESQL parameters must all be of SCALAR type. 2: The directions of each ESQL and Database parameter (IN / OUT / INOUT) must match. 3: The number of parameters in both the ESQL and database definitions must match.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » stored procedure

Jump to:

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

Protected by Anti-Spam ACP