If the path name specified in the create proxy_table statement contains the ;R extension, Component Integration Services traverses all directories subordinate to the path name, and returns information for the contents of each subordinate directory.
When this is done, the file name returned by a query contains the complete name of the file relative to the path name. In other words, all subordinate directory names appear in the file name. For example, if path name specifies “/work;R”:
create proxy_table d1 external directory at "/work;R" select filename, filetype from d1