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.
