Functions

OAROLLBACK

oarollback rolls back an indexing transaction that involves oadeleteindex, oainsertindex, or oaupdateindex, to the most recent call to oabegin, or to a savepoint set in a call to oasavepoint.

This includes index transactions that were posted using oabegin’s IMMEDIATE option or oasavepoint’s IMMEDIATE or ROLLFORWARD option. Once rolled back to oabegin, index updates cannot be rolled forward again or committed, and the entire indexing transaction is cancelled. Therefore, the update application should verify that the native update failed before calling oarollback to roll back the corresponding updates to Omnidex indexes.

When you roll back to a savepoint, as passed through the savepoint parameter, you don’t cancel the entire transaction. You only negate the portion of the transaction that failed. Therefore, you may want to set savepoints at strategic points in a series of update transactions

Transaction management applies to the Omnidex indexes only. If transaction management is required for the database, use the DBMS transaction management system.

See Also: ODXAIM

Syntax

oarollback (instance, options, status, savepoint)

instance -- Identifies the unique connection to a catalog established by calling oaconnect. Instance is a 32-bit signed integer passed by value.

options -- Is a character string, passed by reference, that indicates the action(s) for oarollback to take. Terminate the option list with a semicolon or a null character. If options contains only a semicolon or null character, oasavepoint defaults to the DELAYED option.

status -- Indicates the success or failure of the oarollback routine. A zero status.error means a successful call to oarollback. The status structure is passed by reference and contains fourteen 32-bit signed integers, followed by a 36-character buffer.

savepoint -- Is a character string passed by reference that declares a particular savepoint set by a preceding call to oasavepoint. If a rollback is required, oarollback undoes index transactions back to this point. This prevents the cancellation of an entire transaction.

Options

DELAYED -- causes subsequent indexing transactions to be posted only after a call to either oacommit, or oasavepoint with the ROLLFORWARD option.

IMMEDIATE -- causes subsequent indexing transactions to be posted immediately.

Example

Top