The following table describes the columns in the DB2 Catalog Synchronization Information sequential file for EXTERNAL KEY:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| RECFMT | CHARACTER | 001-004 | 4 | EKEY |
| Separator | CHARACTER | 005-005 | 1 | must be blank |
| IXNAME | CHARACTER | 006-133 | 128 | index name (mandatory field) |
| Separator | CHARACTER | 134-134 | 1 | must be blank |
| IXCREATOR | CHARACTER | 135-262 | 128 | index creator ( mandatory field) |
| Separator | CHARACTER | 263-263 | 1 | must be blank |
| COLSEQ | CHARACTER | 264-267 | 4 | column sequence ( mandatory field) |
| Separator | CHARACTER | 268-268 | 1 | must be blank |
| COLNAME | CHARACTER | 269-298 | 30 | column name ( mandatory field). |
| Separator | CHARACTER | 299-299 | 1 | must be blank |
| COLNO | CHARACTER | 300-303 | 4 | column number ( mandatory field) |