Creating columns for a subscription

Use the Create Column window to create new columns in 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 new column is called a computed column.

Fields and controls



To create columns for a subscription:

  1. Open the Create 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. For renamed columns, the SQL expression should be the original column name from the source table.
  6. Click on OK to save the definition and return to the Target Columns page of the Advanced Subscription Definition notebook.


Related information