Stored Procedure Call

chinnaraj · New User Joined: 01 Nov 2007 Posts: 17 Location: Chennai

Hi

i got the following erroe when i tried to call a stored procedure.

SQLCODE: 000000471
SQLERRMC: AAAAAAA.BBBBBBBBBBBBBB:00E79001

i googled out the error and found the cause as 'Stored procedure was stopped' and the resolution provided is 'Start the stored procedure using DB2 Start Procedure command.'.

pls help to me how to go about this.

Regards,
chinna.

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Find the Abend assist screen shot in the attachment.
That might help you.

rpuhlman · Posted: Fri Sep 12, 2008 8:27 pm

Chinna,

How were you trying to invoke the stored procedure? COBOL? QMF?

Rick

chinnaraj · New User Joined: 01 Nov 2007 Posts: 17 Location: Chennai

Hi Rick,

i am calling the SP thru COBOL program with the required parameters.

Thanks,
Chinna.

paritosh mathur · New User Joined: 10 Apr 2006 Posts: 14

my team also encountered this problem.
please revisit your stored procedure code and check if you are passing some thing wrong in sql queries, cursors.
like date, time which is not in db2 format. same with numeric items.

Suresh Ponnusamy · Posted: Mon Sep 15, 2008 8:04 pm

Hi

If the Stored Procedure is stopped, Please restart the Stored Procedure.. If you do not have access, you can contact your DBA.