Microsoft SQL Server Database stored procedures summary

When you use database stored procedures in a PowerBuilder application, keep the following points in mind:

  • Manipulating stored procedures

    To manipulate database stored procedures, PowerBuilder provides SQL statements that are similar to cursor statements.

  • Retrieval and update

    PowerBuilder supports retrieval, update, or a combination of retrieval and update in database stored procedures, including procedures that return no results sets and those that return one or more result sets.

  • Transactions and stored procedures with result sets

    When a procedure executes successfully using a specific connection (transaction) and returns at least one result set, no other SQL commands can be executed using that connection until the procedure has been closed.

  • Transactions and stored procedures without result sets

    When a procedure executes successfully using a specific transaction but does not return a result set, the procedure is no longer active. No result sets are pending, and therefore a CLOSE statement is not required.