There are several basic elements required to access remote
data.
Remote table mappings
SAP Sybase IQ presents tables to a client application as if all the data in the tables were stored in the database to which the application is connected. Internally, when a query involving remote tables is executed, the storage location is determined, and the remote location is accessed so that data can be retrieved.
Server classes for remote data access
The server class you specify in the CREATE SERVER statement determines the behavior of a remote connection. The server classes give SAP Sybase IQ detailed server capability information. SAP Sybase IQ formats SQL statements specific to a server's capabilities.