>HELP
> I need to know if a table is being used localy when a (fileserver) view is being accessed. If the table is being pulled down localy or into memory is there a way to avoid this. The table DBC lives on the server and the view DBC lives on the local drive.
>
>Thanks
You can test this yourself with the USED() function. In general, if you have created a remote view in the local DBC, the table will not be USED() and the remote DBC will not be DBUSED(). If you created a local view, functions return true.
Mark McCasland
Midlothian, TX USA