Contents Index RELEASE SAVEPOINT statement REMOVE JAVA statement

ASA SQL Reference
  SQL Statements

REMOTE RESET statement [SQL Remote]


Description 

Use this statement in custom database-extraction procedures to start all subscriptions for a remote user in a single transaction.

Syntax 

REMOTE RESET userid

Usage 

This command starts all subscriptions for a remote user in a single transaction. It sets the log_sent and confirm_sent values in SYSREMOTEUSER table to the current position in the transaction log. It also sets the created and started values in SYSSUBSCRIPTION to the current position in the transaction log for all subscriptions for this remote user. The statement does not do a commit. You must do an explicit commit after this call.

In order to write an extraction process that is safe on a live database, the data must be extracted at isolation level 3 in the same transaction as the subscriptions are started.

This statement is an alternative to start subscription. START SUBSCRIPTION has an implicit commit as a side effect, so that if a remote user has several subscriptions, it is impossible to start them all in one transaction using START SUBSCRIPTION.

Permissions 

Must have DBA authority.

Side effects 

No automatic commit is done by this statement.

See also 

START SUBSCRIPTION statement [SQL Remote]

Example 

Contents Index RELEASE SAVEPOINT statement REMOVE JAVA statement