Specifying SQL run-time processing statements

Use the SQL window to add, change, or remove run-time SQL processing statements that will be submitted either before or after the subscription is processed.

To specify SQL run-time processing statements:

1. Open the SQL window.

2. Click on the Add push button. The Add SQL window opens so that you can add run-time SQL processing statements.

3. After adding your run-time SQL processing statements, click on OK to return to the Define Subscription window.

Related information

• Defining a subscription
• Advanced Subscription Definition - Overview
• Specifying read-only, replica, or row replica target tables for a subscription
• Specifying target columns for a subscription
• Specifying a subset of rows for a subscription
• Subscription Timing - Overview
• Specifying the number of minutes at a time that Apply will copy committed data
• Running an SQL file now or later

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

[ DB2 List of Books | Search the DB2 Books ]