Sybase Adaptive Server Anywhere - Page 460

CREATE EXISTING TABLE statement
442
♦ Data types in the CREATE EXISTING TABLE statement must match
or be convertible to the data types of the column on the remote location.
For example, a local column data type is defined as money, while the
remote column data type is numeric.
♦ Each column’s NULL property is checked. If the local column’s NULL
property is not identical to the remote column’s NULL property, a
warning message is issued, but the statement is not aborted.
♦ Each column’s length is checked. If the length of char, varchar, binary,
varbinary, decimal and numeric columns do not match, a warning
message is issued, but the command is not aborted.
You may choose to include only a subset of the actual remote column
list in your CREATE EXISTING statement.
AT clause The AT clause specifies the location of the remote object. The
AT clause supports the semicolon (;) as a delimiter. If a semicolon is present
anywhere in the location-string string, the semicolon is the field delimiter. If
no semicolon is present, a period is the field delimiter. This allows filenames
and extensions to be used in the database and owner fields. For example, the
following statement maps the table a1 to the MS Access file
mydbfile.mdb :
CREATE EXISTING TABLE a1
AT ’access;d:\mydbfile.mdb;;a1’
♦ SQL/92 Entry-level feature.
♦
Sybase Supported by Open Client/Open Server.
♦ Create a proxy table named
blurbs for the blurbs table at the remote
server
server_a .
CREATE EXISTING TABLE blurbs
( author_id id not null,
copy text not null)
AT ’server_a.db1.joe.blurbs’
♦ Create a proxy table named blurbs for the blurbs table at the remote
server
server_a . Adaptive Server Anywhere derives the column list from
the metadata it obtains from the remote table.
CREATE EXISTING TABLE blurbs
AT ’server_a.db1.joe.blurbs’
♦ Create a proxy table named rda_employee for the employee table at the
Adaptive Server Anywhere remote server
asademo .
CREATE EXISTING TABLE rda_employee
AT ’asademo..dba.employee’
Parameters
Standards and
compatibility
Examples