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
 

 

Error while Executing Stored procedure

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

New User


Joined: 26 Sep 2007
Posts: 42
Location: pune

PostPosted: Fri Mar 19, 2010 11:17 pm    Post subject: Error while Executing Stored procedure
Reply with quote

Hi All I am writing stored procedure first time
and i am calling it using cobol program i getting -440 SQLCODE while doing bind
following is the erro in spool
BIND PACKAGE(PAAILS00) MEMBER(AAISPCAT) OWNER(DBTPAAI) QUALIF
ATA(NO) RELEASE(COMMIT) EXPLAIN(YES) ACTION(REPLACE)
DSNX200I -DB81 BIND SQL ERROR
USING DBTPAAI AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=AAISPCAT
STATEMENT=142
SQLCODE=-440
SQLSTATE=42884
TOKENS=PROCEDURE ALERT_SUMMARY_BY_OFFICEAPP
CSECT NAME=DSNXOSTP
RDS CODE=1245192
DSNT233I -DB81 UNSUCCESSFUL BIND FOR
PACKAGE = DB81.PAAILS00.AAISPCAT.()
DSN


Following the stored procedure call in cobol

EXEC SQL
CALL ALERT_SUMMARY_BY_OFFICEAPP
(:WS-EDB-SINP,:WS-AAISPCF-INP , :WS-STD-OPT,:WS-APL-OPT)
END-EXEC.

Please help me out
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: Fri Mar 19, 2010 11:36 pm    Post subject:
Reply with quote

Hello,

Did you look here?
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.178

At the top of the page is a link to "IBM Manuals". You will want to become both familiar and comfortable with many of them. . .
Back to top
View user's profile Send private message
Ragav86

New User


Joined: 27 Jan 2010
Posts: 37
Location: chennai

PostPosted: Wed Mar 24, 2010 3:46 pm    Post subject: Reply to: Error while Executing Stored procedure
Reply with quote

verify your stored procedure call with sysibm.sysparm tables
whether you have mentioned all the parameters and data types correctly?
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Wed Mar 24, 2010 4:56 pm    Post subject:
Reply with quote

Also check whether the environment where you are trying to BIND the program has this SP or not. I mean the QUALIFIER with which you are BINDING the program should have the Stored Procedure defined in it.
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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
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 S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm


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