Recursion through subordinate directories

If the "pathname" specified in the create proxy_table statement contains the ;R extension, CIS traverses all directories subordinate to pathname, returning information for the contents of each subordinate directory. When this is done, the filename returned by a query contains the complete name of the file relative to the pathname. In other words, all subordinate directory names appear in the filename. For example, if pathname specifies "/work;R":

create proxy_table d1 external directory at "/work;R"
select filename, filetype from d1

returns values for files in subordinate directories as follows:

**Table 2-4: Values for files**
Filename	Filetype
dir1	DIR
dir1/file1.c	REG
dir1/file2.c	REG
dir2	DIR
dir2/file1.c	REG