Table synonym and alias record (DTOB)
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DTOB - Table Synonym and Alias Record |
SYSID | 04 | 04 | CHAR(4) | Originating SYSID |
DBID | 08 | 08 | CHAR(4) | Database ID (hexadecimal) of table associated with synonym or alias |
PSID | 12 | 0C | CHAR(4) | Table space PSID (hexadecimal, page set descriptor) of table associated with synonym or alias |
OBID | 16 | 10 | CHAR(4) | Table ID (hexadecimal) of table associated with synonym or alias |
OBJTYPE | 20 | 14 | CHAR(1) | Type of object: S - synonym A - alias |
OBJCREATORLEN | 21 | 15 | CHAR(3) | Length of the creator portion of the synonym or alias name |
OBJCREATOR | 24 | 18 | CHAR(128) | Creator of the synonym or alias |
OBJNAMELEN | 152 | 98 | CHAR(3) | Length of the synonym or alias name |
OBJNAME | 155 | 9B | CHAR(128) | Name of the synonym or alias |
(Total Length) | 283 | 11B | Not applicable | Not applicable |