Subscription name
Submit SQL before or after
SQL statement
SQLSTATE
Add
Remove
OK
Cancel
Subscription name
Submit SQL before or after
SQL statement
SQLSTATE
Add
Remove
OK
Cancel
Subscription name
This field displays the subscription name that you specified in the Define Subscription window.
Submit SQL before or after
This field specifies whether the SQL is to be submitted before or after the subscription is processed. You specify this setting in the Add SQL window.
SQL statement
This field displays the SQL statement or procedure name. Click on Add to open the Add SQL window so that you can add a statement or procedure to this field.
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.
SQLSTATE
This box displays SQLSTATE values. These values are to be interpreted as successful executions. To add values to this list, click on Add to open the Add 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. For example, if you enter 02000 as an acceptable SQLSTATE, your subscription will not fail while executing SQL-BEFORE or SQL-AFTER statements.
Add
Click on this push button to open the Add SQL window to add SQL run-time statements with their acceptable SQLSTATE values.
Remove
Click on this push button to remove the SQL statement and SQLSTATE that you selected in the window.
