For each external table, at least one row exists in the sysextdfiles system catalog table, which has the following columns.
| Column | Type | Explanation |
|---|---|---|
| tabid | INTEGER | Unique identifying code of an external table |
| dfentry | CHAR(152) | Data file entry |
You can use DBSCHEMA to write out the description of the external tables. To query these system catalog tables about an external table, use the tabid as stored in systables with tabtype = 'E'.
An index on the tabid column allows duplicate values.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]