| View previous topic :: View next topic |
| Author |
Message |
shreyas_e
Beginner
Joined: 06 Nov 2017
Posts: 10
Topics: 4
|
 Posted: Thu Apr 04, 2019 12:10 pm Post subject: SQLCODE -567 while creating stored procedure |
 |
|
Hi,
I am trying to create the below stored procedure. This is the first time I am trying to create a Stored procedure.
| Code: | SET CURRENT SQLID = 'M3DEVL';
CREATE PROCEDURE UPDATESALARY2
(IN EMPNUMBER INTEGER)
LANGUAGE SQL
MODIFIES SQL DATA
UPDATE EMPTABLE
SET EMPSAL = EMPSAL * 3
WHERE EMPNO = EMPNUMBER; |
I get the below error. Any pointers on how to get this resolved. I have an application program with DB2 statements and was able bind the package to M11PLOC.DEVLGCBATCH.*. However, when I try to create a procedure it tries with M11PLOC.M3DEVL.*. How do we default the package to M11PLOC.DEVLGCBATCH.* for which I have bind authority.
| Code: | DSNT408I SQLCODE = -567, ERROR: REBIND AUTHORIZATION ERROR USING M3DEVL
AUTHORITY PACKAGE = M11PLOC.M3DEVL.UPDATESALARY2.(V1) PRIVILEGE =
CREATE IN |
Thanks in Advance |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12367
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
shreyas_e
Beginner
Joined: 06 Nov 2017
Posts: 10
Topics: 4
|
| Posted: Thu Apr 04, 2019 3:51 pm Post subject: |
|
|
Hi Kolusu,
Thanks for looking in to this. We have DB2 10, 11 and 12. In all the versions i get the same error. Not sure if this is something else, before reaching out to DB2 Admin.
Thanks
Shreyas |
|
| Back to top |
|
|
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Thu Apr 04, 2019 5:31 pm Post subject: |
|
|
DB2 Admin is your second port of call - after your colleagues. A forum should be your last.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
