Retrieval and update

You can use database stored procedures for:

• Retrieval only

• Update only

• Retrieval and update

Your DBMS

Not all DBMSs support these retrieval and update options.

Using stored procedures

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

• Manipulating stored procedures

  PowerBuilder provides SQL statements that are similar to cursor
  statements for manipulating database stored procedures.

• Retrieval and update

  PowerBuilder supports retrieval, update, or a combination
  of retrieval and update in database stored procedures, including
  procedures that do not return a result set and those that return
  a result set.

• Transactions and stored procedures
  without result sets

  When a procedure executes using a particular connection (transaction)
  and the procedure does not return a result set, the procedure is
  no longer active. No result set is pending, and therefore you do
  not execute a CLOSE statement.

See also

• OLE DB Retrieval

• OLE DB Using database stored procedures in DataWindow objects