IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error while Executing Stored procedure


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Fri Mar 19, 2010 11:36 pm
Reply with quote

Hello,

Did you look here?
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top