1. Joseph John
  2. PowerServer Web
  3. Thursday, 10 January 2019

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 ?

 

 

Who is viewing this page
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Joseph;

   BTW: What version of DB/2 and client driver are you using?

FYI: https://www.appeon.com/support/documents/appeon_online_help/2017/server_configuration_guide_for_net/supported_database_drivers.html

Regards ... Chris

Comment
Hi Chris,



The DB2 client installed on the server running Powerserver is DB2 connect unlimited 10.5 (source: DB2_DSDriver_10.5.0.3_Win_x86-64 ) and DB2 version is 8.1 on z/OS ( mainframe)



Does Powerserver support DB2 version 8.1 on z/OS ? If yes, how can we call stored procedures with parameters.



Thank in Advance
  1. Joseph John
  2. 1 day ago
There are no comments made yet.
Joseph John Accepted Answer Pending Moderation
0
Votes
Undo
 

Hi Chris,

Thanks again for your replay.

Unfortunately, it didn't work. I tried the below code.

DECLARE MYPROC PROCEDURE FOR SYSPROC.PROCNAME 
lParm1 = 'TEST'  using SQLCA;

EXECUTE MYPROC ;

but SQLCA.SQLErrtext  is showing the same error.

---------------------------
Error
---------------------------
ERROR [42884] [IBM][DB2] SQL0440N No authorized routine named "PROCNAME" of type "" having compatible arguments was found.
---------------------------
OK 
---------------------------

 Please note that in PB2017, the same code is working fine.

TIA,

 

Comment
There are no comments made yet.
Joseph John Accepted Answer Pending Moderation
0
Votes
Undo

Hi Chris,

Thanks again for your replay.

Unfortunately, it didn't work. I tried the below code.

DECLARE MYPROC PROCEDURE FOR SYSPROC.PROCNAME 
lParm1 = 'TEST'  using SQLCA;

EXECUTE MYPROC ;

but SQLCA.SQLErrtext  is showing the same error.

---------------------------
Error
---------------------------
ERROR [42884] [IBM][DB2] SQL0440N No authorized routine named "PROCNAME" of type "" having compatible arguments was found.
---------------------------
OK
---------------------------

 Please note that in PB2017, the same code is working fine.

TIA,

 

Comment
Ok. So we can eliminate that aspect.

I am assume that all your Apps DML is working except the SP's?
  1. Chris Pollach
  2. 3 days ago
Hi Chris,

Indeed. all DML activities are working fine except SP call.

Maybe any DBParam settings we need to focus?

  1. Joseph John
  2. 2 days ago
Hi Chris,

I have tested an SP which is not accepting or returning any values. That works fine.

It works with RPC also ( SQLCA.ProcName() ) .

so the issue is when passing any parameters.

Any thoughts?

  1. Joseph John
  2. 2 days ago
There are no comments made yet.
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Joseph;

  RPC's are not supported in PowerServer. You would need to convert this to standard DML for SP's. For example, using Declare, Open, Execute & Fetch commands. The other alternative is SP based DataWindow's.

FYI; https://www.appeon.com/support/documents/appeon_online_help/2.0/features_help_for_appeon_mobile/ch05s06.html

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.