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 DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


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