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 setsWhen 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 setsWhen 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.