Changing columns for a subscription

Use the Change Column window to change columns for a subscription to be copied into a target table. The value of a column is derived from an SQL expression involving one or more after-image columns of the source table. You can compute average values, minimum and maximum values, sums, and so on. The changed column is called a computed column.

To change columns for a subscription:

1. Open the Change Column window.

2. Examine the available columns in the Available columns field.

3. Type the name of the new column (up to 18 single-byte characters) in the Column name field.

4. Optional: Click on Examples to show samples of valid SQL expressions.

5. Type an SQL expression for the column in the SQL expression field.

6. Click on OK to save the definition and return to the Target Columns page of the Advanced Subscription Definition notebook.

Related information

• Setting up sources and targets for a subscription
• 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

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

[ DB2 List of Books | Search the DB2 Books ]