Defining individual object storage locations is done by means of the system procedure sp_addobjectdef or the use of the at pathname syntax. This procedure allows you to associate a remote object with a local proxy table name. The remote object may or may not exist before you do the mapping. Complete syntax for sp_addobjectdef is provided in the Adaptive Server Reference Manual.
An easier method for defining storage locations is with the create proxy_table command.
create proxy_table <table_name> [external file] at "pathname"