Step 2: declare the stored procedure as an external function – PB Docs 2021

To declare stored procedures as external functions for the user
object:

1. In the Script view in the User Object painter, select
   [Declare] from the first list and Local External Functions from the
   second list.

2. Place your cursor in the Declare Local External Functions
   view. From the pop-up menu or the Edit menu, select Paste
   Special>SQL>Remote Stored Procedures.

   PowerBuilder loads the stored procedures from your database
   and displays the Remote Stored Procedures dialog box. It lists the
   names of stored procedures in the current database.

   

3. Select the names of one or more stored procedures that you
   want to declare as functions for the user object, and click
   OK.

   PowerBuilder retrieves the stored procedure declarations from
   the database and pastes each declaration into the view.

   For example, here is the declaration that displays on one line
   when you select sp_addlanguage:

   PowerBuilder

   function long sp_addlanguage() RPCFUNC ALIAS FOR "dbo.sp_addlanguage"

   1 2	function long sp_addlanguage() RPCFUNC ALIAS FOR "dbo.sp_addlanguage"

4. Edit the stored procedure declaration as needed for your
   application.

   Use either of the following syntax formats to declare the
   database remote procedure call (RPC) as an external function or
   external subroutine (for details about the syntax, see the section called “Declaring DBMS stored procedures as remote procedure
   calls” in PowerScript Reference):

   PowerBuilder

   FUNCTION rtndatatype functionname ( { { REF } datatype1 arg1, ..., { REF } datatypen argn } ) RPCFUNC { ALIAS FOR "spname" } SUBROUTINE functionname ( { { REF } datatype1 arg1 , ..., { REF } datatypen argn } ) RPCFUNC { ALIAS FOR "spname" }

   1 2 3 4 5

   FUNCTION rtndatatype functionname ( { { REF } datatype1 arg1, ...,    { REF } datatypen argn } ) RPCFUNC { ALIAS FOR "spname" }   SUBROUTINE functionname ( { { REF } datatype1 arg1 , ...,    { REF } datatypen argn } ) RPCFUNC { ALIAS FOR "spname" }

   Here is the edited RPC function declaration for
   sp_addlanguage:

   PowerBuilder

   FUNCTION long sp_addlanguage() RPCFUNC ALIAS FOR "addlanguage_proc"

   1 2	FUNCTION long sp_addlanguage()       RPCFUNC ALIAS FOR "addlanguage_proc"