View previous topic :: View next topic
|
Author |
Message |
Satish5
New User
Joined: 12 Nov 2007 Posts: 38 Location: Texas, USA
|
|
|
|
Hi,
I am getting SQLCODE -727 on executing a Stored Procedure on DB2/AIX server. No other message is displayed in abend log. Can anyone please suggest what is this error and possible solutions. I tried searching on internet but no result.
Thanks in advance
Regards,
Satish |
|
Back to top |
|
|
Satish5
New User
Joined: 12 Nov 2007 Posts: 38 Location: Texas, USA
|
|
|
|
Also this procedure is running fine in test environment but abending in production environment. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
You tried the internet but did you try the manual? Have you got a reson code? How does this relate to mainframe? |
|
Back to top |
|
|
Satish5
New User
Joined: 12 Nov 2007 Posts: 38 Location: Texas, USA
|
|
|
|
Yes I searched through manuals also but did not get reason code or any other relevant information. Infact this SQLCODE -727 is not even listed on SQL codes list.
This is not running on mainframe. I apologize for posting on mainframe forum. But I am badly stuck and desperate to get any solution or even any hint on solving this issue. Any help would be appreciated.
Regards,
Satish |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
Back to top |
|
|
Satish5
New User
Joined: 12 Nov 2007 Posts: 38 Location: Texas, USA
|
|
|
|
Hi,
Issue was that user did not have access to a particular table acccessed in proc. It is reolved now. Thanks for resposne.
Thanks for the help.
Regards,
Satish |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
Quote: |
Issue was that user did not have access to a particular table acccessed in proc. |
My understanding is that you just need to have EXECUTE access to the stored proc. Access on underlying tables is not required. That's one of the feature makes stored procedures secure. Users are prevented from manipulating the underlying data through normal SQL.
I am glad that your issue is resolved but I doubt it was due to access issue on underlying tables. |
|
Back to top |
|
|
|