1. Joseph John
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 10 January 2019 16: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 ?

 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 14 January 2019 20:54 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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
  1. Joseph John
  2. Tuesday, 15 January 2019 16:18 PM UTC
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. Helpful
There are no comments made yet.
Joseph John Accepted Answer Pending Moderation
  1. Friday, 11 January 2019 16:44 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2
 

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
  1. Friday, 11 January 2019 16:26 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

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
  1. Chris Pollach @Appeon
  2. Sunday, 13 January 2019 17:08 PM UTC
Ok. So we can eliminate that aspect.

I am assume that all your Apps DML is working except the SP's?
  1. Helpful
  1. Joseph John
  2. Monday, 14 January 2019 09:06 AM UTC
Hi Chris,

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

Maybe any DBParam settings we need to focus?

  1. Helpful
  1. Joseph John
  2. Monday, 14 January 2019 16:12 PM UTC
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. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 10 January 2019 18:54 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

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.