>I call the following from the Load to set the relative path to the tables. What has me baffled is that the views seem to be referenced just like a table is so if I try to do a FILE(...) it fails because it is not a physical table.

For checking if you have the view you can use:

IF INDBC("myview","View").....

With the DBC opened