External file system support

Adaptive Server enables SQL access to file system directories and their underlying files. The supported syntax is:

create [existing] table fname
external file at "directory_pathname” column delimiter “delimiter

The directory path name must reference a file system directory that is visible to and searchable by Adaptive Server. A proxy table maps column names to attributes of files that exist within the directory. Individual columns, except for the last one, are delimited by the column delimiter specified in the create table syntax.