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.
Fields and controls
To change columns for a subscription:
- Open the Change Column window.
- Examine the available columns in the Available
columns field.
- Type the name of the new column (up to 18 single-byte characters) in the
Column name field.
- Optional: Click on Examples to
show samples of valid SQL expressions.
- Type an SQL expression for the column in the SQL
expression field.
- Click on OK to save the definition and return to the Target
Columns page of the Advanced Subscription Definition notebook.
Related information