Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQL error code as -471(DB2 subroutine cannot be called)

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

New User


Joined: 24 Jul 2007
Posts: 18
Location: india

PostPosted: Sat May 29, 2010 12:32 am    Post subject: SQL error code as -471(DB2 subroutine cannot be called)
Reply with quote

Hi,

I have a main program A (Batch DB2) which calls a stored procedure B. while calling B from A , I get SQL error code as -471(DB2 subroutine cannot be called properly).
I also have another stored proc D which is successfully called by another batch DB2 program C.

Both A and B were complied in similar way as C and D via changeman.
But I was getting -471 for A and B only.
I even copied the same code from C and D in A and B respectively (just to make sure that this was not because of any coding issue) but still I t was giving same error.

I guess it has something to do with the changeman only. Any pointers??????????

This might look like a simple problem but I spen whole day resolving this. Please excuse me if there is some simple solution to this problem which I am not able to think.

Thanks in advance.

Big C

Thanks for help in advance.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat May 29, 2010 12:43 am    Post subject:
Reply with quote

Hello,

Is there some reason you did not post the reason code?

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.194
Back to top
View user's profile Send private message
chitra_chaturvedi

New User


Joined: 24 Jul 2007
Posts: 18
Location: india

PostPosted: Sat May 29, 2010 12:12 pm    Post subject:
Reply with quote

Thanks Dick,

I am not able to see any reason code.

Also I am feeling that somehow some entry has not been made in some table for the stored procedure.

Could you please let me know in what all places a DB2 stored procedure is registered?

Thanks
Back to top
View user's profile Send private message
Pradip kumar Mohanty

New User


Joined: 16 Sep 2007
Posts: 33
Location: India

PostPosted: Sat May 29, 2010 12:29 pm    Post subject:
Reply with quote

Chitra,

Information about stored procedures is stored in SYSIBM.SYSROUTINES catalog table and all the parameters should be be in SYSIBM.SYSPARMS.

I would advise you to revisit the preparation steps. Is it link-edited with either DSNALI or DSNRLI ( per the attachment facility you want to use).

Regards,
Pradip Mohanty
TSYS International.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Sat May 29, 2010 7:49 pm    Post subject:
Reply with quote

First check whether your routine is in stop state from DB2 command line. If its stopped, start it.
Secondly check whether the SP has been defined correctly to run in the required WLM env.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Sat May 29, 2010 7:55 pm    Post subject:
Reply with quote

if the TS would bother to look at the sqlca msgs provided at receipt of sql code -471,
he would have the reason code available,
and thus not have to check everything under the sun.

that is why reason codes are provided.

considering the level of skill of the TS,
having him check on the status of anything is probably above his level.

teach him how to find the reason code,
and in the future the TS may have more developed debugging skills.
Back to top
View user's profile Send private message
dineshsam

New User


Joined: 30 Aug 2007
Posts: 1
Location: Chennai

PostPosted: Mon May 31, 2010 3:18 pm    Post subject:
Reply with quote

Hi,

I guess the following link will help you..

http://publib.boulder.ibm.com/infocenter/pdthelp/v1r1/index.jsp?topic=/com.ibm.debugtool.doc_6.1/eqa6ug02420.htm

Thanks,
Dinesh
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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us