Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Stored Procedure Call

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
chinnaraj

New User


Joined: 01 Nov 2007
Posts: 17
Location: Chennai

PostPosted: Fri Sep 12, 2008 5:10 pm    Post subject: Stored Procedure Call
Reply with quote

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.
Back to top
View user's profile Send private message

muthukannan

New User


Joined: 03 Aug 2006
Posts: 42
Location: Chennai

PostPosted: Fri Sep 12, 2008 6:15 pm    Post subject: Reply to: Stored Procedure Call
Reply with quote

Find the Abend assist screen shot in the attachment.
That might help you.
Back to top
View user's profile Send private message
rpuhlman

New User


Joined: 11 Jun 2007
Posts: 80
Location: Columbus, Ohio

PostPosted: Fri Sep 12, 2008 8:27 pm    Post subject:
Reply with quote

Chinna,

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

Rick
Back to top
View user's profile Send private message
chinnaraj

New User


Joined: 01 Nov 2007
Posts: 17
Location: Chennai

PostPosted: Mon Sep 15, 2008 11:23 am    Post subject: Reply to: Stored Procedure Call
Reply with quote

Hi Rick,

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

Thanks,
Chinna.
Back to top
View user's profile Send private message
paritosh mathur

New User


Joined: 10 Apr 2006
Posts: 14

PostPosted: Mon Sep 15, 2008 12:48 pm    Post subject: Stored Procedure Call
Reply with quote

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.
Back to top
View user's profile Send private message
Suresh Ponnusamy

Active User


Joined: 22 Feb 2008
Posts: 107
Location: New York

PostPosted: Mon Sep 15, 2008 8:04 pm    Post subject:
Reply with quote

Hi

If the Stored Procedure is stopped, Please restart the Stored Procedure.. If you do not have access, you can contact your DBA.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Cobol EZASOKET call to SETSOCKOPT fails Andi1982 COBOL Programming 6 Thu Oct 06, 2016 7:12 pm
No new posts Strange EXEC function call in z/VM Willy Jensen CLIST & REXX 3 Wed Oct 05, 2016 2:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us