Adding run-time processing statements to the SQL statement box

Use the Add SQL window to add run-time SQL processing statements to the SQL window.

To add run-time processing statements to the SQL statements list:

1. Type the processing statement or stored procedure name in the SQL statement field. The keyword CALL must precede a stored procedure name.

2. Optional: Type an acceptable 5-byte SQLSTATE value in the SQLSTATE field and click on Add. The value is added to the Acceptable SQLSTATE values list box. You can enter up to 10 values. The replication program interprets these values as successful execution. You can remove an acceptable SQLSTATE value by clicking on one or more values and then clicking on the Remove push button.

3. Specify when you want to submit the statement, and on which server (target or source), by clicking on the appropriate radio button in the Submit SQL statement field.

4. Click on OK. The statement is added to the box in the SQL window, and the Add SQL window closes.

Related information

• Defining a subscription
• Specifying SQL run-time processing statements

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]