DB2 Replication Guide and Reference
When the change data table is created, the last character of the column
name is truncated when the before-image column identifier (usually x)
is added to it. The column name is truncated because DB2 limits column
names to 18 characters. Therefore, before image data cannot be captured
and replicated except with the following restrictions:
- On MVS, you can use 18-character column names but the first 17 characters
of the column name must be unique within a table. (The 18th character
will be replaced by the before image column identifier.)
- On all other platforms, column names can be a maximum of 17 characters and
must be unique within a table.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]