Remote Servers

Before remote objects can be mapped to a local proxy table, define the remote server where the remote object is located.

• Create Remote Servers
  Use the CREATE SERVER statement to set up remote server definitions.
• Before You Access Remote Oracle Data
  To access remote Oracle data, configure your system with the prerequisite software.
• Connecting to an Oracle Database
  Connect SAP Sybase IQ to remote Oracle data via Component Integration Services.
• Troubleshoot Oracle Database Access
  If Oracle data access returns errors, check the appropriate configuration component.
• Loading Remote Data Without Native Classes
  Load data by using DirectConnect.
• Querying Data Without Native Classes
  Follow these guidelines to query data without native classes.
• Delete Remote Servers
  Use the DROP SERVER statement to delete a remote server from the ISYSSERVER system table.
• Alter Remote Servers
  Use the ALTER SERVER statement to modify the attributes of a server. These changes do not take effect until the next connection to the remote server.
• Listing the tables on a remote server (SQL)
  You can view a limited or comprehensive list of all the tables on a remote server using a system procedure.
• Remote server capabilities
  The sp_servercaps system procedure displays information about a remote server's capabilities. SAP Sybase IQ uses this capability information to determine how much of a SQL statement can be passed to a remote server.