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. You can specify up to 16 bytes. If you do not specify any, the tab character is used as the default.
