Opening Tables Not Named in the File List
With the as option of the open command, it is possible to open a directory fileset for a table other than the one identified in the file list entry. This can be useful where a group of tables shares a common column structure but has different filenames or directory paths. With open ... as, the directory names and paths of physical filesets can, in fact, even be entered at runtime.
This optional element of open must contain the directory root name of the fileset to be opened (no extensions), plus the directory path where necessary, followed by the word as. Following as, the DataFlex name of an actual .FD file-definition file (created by an entry in the file list) must be given.
The physical fileset must have identical columns in terms of their names, their types, and the order in which they stand in the table, to those of the table actually in the file list.