Creates a proxy table without specifying a column list. Component Integration Services derives the column list from the metadata it obtains from the remote table.
create proxy_table table_name [ external type ] at pathname
create proxy_table is a variant of the create existing table command. You use create proxy_table to create a proxy table, but (unlike create existing table) you do not specify a column list. CIS derives the column list from the metadata it obtains from the remote table.
The location information provided by the at keyword specifies the pathname to the remote object.
If the remote server object does not exist, the command is rejected with an error message.
If the remote object exists, column metadata is obtained from the remote server, and an internal create existing table command is processed.
If the remote server is case insensitive (as is the case with DB2, Oracle, perhaps others), then the case of the generated table and column names is determined by the case of the table_name used with the create proxy_table statement:
if table_name is lower case, the generated proxy table name is also lower case, as are all of its columns
if table_name is uppercase, the generated proxy table name is also upper case, as are all of its columns
The external type can be of three types
external table specifies that the object is a remote table or view. external table is the default, so this clause is optional.
external directory specifies that the object is a directory with a path in the following format: “/tmp/directory_name [;R]”. The option “R” indicates recursive
external file specifies that the object is a file with a path in the following format: “/tmp/filename”
create table and create existing table in the Adaptive Server Reference Manual.