Advanced PowerBuilder

Using a Stored Procedure In PowerScript

As we've already seen, you can execute a stored procedure by specifying it as a data source to a DataWindow. To execute a stored procedure through PowerScript, you can either use Embedded SQL or Dynamic SQL.

There are four steps involved in using a stored procedure through Embedded SQL:

• Declaration.
• Execution.
• Retrieving rows.
• Closing.