Create Column

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.

Controls

• Column name
• SQL expression
• Available columns
• Examples
• OK
• Cancel

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

[ DB2 List of Books | Search the DB2 Books ]