DB2 RPC call error
- Issue
- DB2
- PowerServer
- RPC
- Joseph John
- PowerServer 2020 or older (Obsolete)
- Thursday, 10 January 2019 04:50 PM UTC
Hi ,
We are trying to convert our legacy application build on Powerbuilder 12.5 /DB2 database to Appeon web. We downloaded the Powerbuilder2017 trial version with powerserver. all works okay except the RPC call.
when we are trying to call the Stored procedure ( RPC ( SQLCA.SPname() ) ) , it is throwing below error.
Error
---------------------------
ERROR [42884] [IBM][DB2] SQL0440N No authorized routine named "SP name" of type "" having compatible arguments was found.
---------------------------
OK
---------------------------
any idea how to overcome this issue ?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.