View previous topic :: View next topic
|
Author |
Message |
mosinjamadar
New User
Joined: 26 Sep 2007 Posts: 42 Location: pune
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
Back to top |
|
|
Ragav86
New User
Joined: 27 Jan 2010 Posts: 37 Location: chennai
|
|
|
|
verify your stored procedure call with sysibm.sysparm tables
whether you have mentioned all the parameters and data types correctly? |
|
Back to top |
|
|
mallik4u
New User
Joined: 17 Sep 2008 Posts: 75 Location: bangalore
|
|
|
|
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 |
|
|
|