SYSEXTDFILES

The sysextdfiles system catalog table contains identifying codes and the paths of external tables.

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(469) Absolute source or target file path
blobdir CHAR(344) Absolute or relative directory name
clobdir CHAR(344) Absolute or relative directory name

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.