Microsoft SQL Server DECLARE and EXECUTE – PB Docs 126

Microsoft SQL Server DECLARE and EXECUTE

PowerBuilder requires a declarative statement
to identify the database stored procedure that is being used and
a logical name that can be referenced in subsequent SQL statements.

The general syntax for declaring a procedure is:

where logical_procedure_name can
be any valid PowerScript data identifier and SQL_Server_procedure_name is
the name of the stored procedure in the database.

The parameter references can take the form of any valid parameter
string that SQL Server accepts. PowerBuilder does not inspect the
parameter list format except for purposes of variable substitution.
You must use the reserved word OUTPUT to indicate an output parameter.
The USING clause is required only if you are using a transaction
object other than the default transaction object (SQLCA).

Example 1

Assume a stored procedure proc1 is defined as:

To declare that procedure for processing within PowerBuilder,

Note that this declaration is a nonexecutable statement, just
like a cursor declaration. Where cursors have an OPEN statement,
procedures have an EXECUTE statement.

When an EXECUTE statement executes, the procedure is invoked.
The EXECUTE refers to the logical procedure name:

Example 2

To declare a procedure with input and output parameters, enter:

Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x