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 ?

 

 

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. Tuesday, 15 January 2019
There are no comments made yet.
  1. Monday, 14 January 2019
  2. PowerServer Web
  3. # 1
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.
  1. Friday, 11 January 2019
  2. PowerServer Web
  3. # 2
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. Sunday, 13 January 2019
Hi Chris,

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

Maybe any DBParam settings we need to focus?

  1. Joseph John
  2. Monday, 14 January 2019
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. Monday, 14 January 2019
There are no comments made yet.
  1. Friday, 11 January 2019
  2. PowerServer Web
  3. # 3
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.
  1. Thursday, 10 January 2019
  2. PowerServer Web
  3. # 4
  • Page :
  • 1


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