ODBC Database stored procedures

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

ODBC Retrieval

ODBC Using database stored procedures in DataWindow objects