Chapter 9 SQL Statements
465
READ ONLY The READ ONLY clause specifies that the remote server is
a read-only data source. Any update request is rejected by Adaptive Server
Anywhere.
♦
SQL/92 Entry-level feature.
♦
Sybase Supported by Open Client/Open Server.
♦ Create an Adaptive Server Anywhere remote server named
testasa,
located on the machine
apple
and listening on port number 2638, use:
CREATE SERVER testasa
CLASS ’asajdbc’
USING ’apple:2638’
♦ Create a remote server for the JDBC-based Adaptive Server named
ase_prod
. Its machine name is banana and port number is 3025.
CREATE SERVER ase_prod
CLASS ’asejdbc’
USING ’banana:3025’
♦ Create a remote server for the Oracle server named oracle723. Its ODBC
Data Source Name is
oracle723
.
CREATE SERVER oracle723
CLASS ’oraodbc’
USING ’oracle723’
Standards and
compatibility
Examples
To Next Page
Loading...