Add SQL -- Fields and controls

SQL statement

SQLSTATE

Add

Remove

Submit SQL statement

OK

Cancel

SQL statement

Type the SQL statement or procedure name that you want to add to the SQL window.

After an SQL statement is processed, a subscription will fail on a nonzero SQLSTATE, unless you specifically list a nonzero SQLSTATE in the SQLSTATE box.

This field:

• Can contain up to 254 single-byte characters, excluding double quotes.
• Can be an ordinary or delimited identifier

SQLSTATE

Optional: Type a five-byte SQLSTATE that the replication program will interpret as successful execution, and click on Add to add it to the box. This field has no default value.

Add

Click on this push button to add the value in the SQLSTATE field to the SQLSTATE box.

Remove

Click on this push button to remove the selected SQLSTATE value from the SQLSTATE box.

Submit SQL statement

Select a radio button to specify when, and on which server, the SQL statements are to be submitted:

At the target server before the subscription is processed

Run SQL statements or procedure calls at the target server before the subscription processing starts.

At the source server before the subscription is processed

Run SQL statements or procedure calls at the source server before the subscription processing starts.

At the target server after the subscription is processed

Run SQL statements or procedure calls at the target server after the subscription processing stops.