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 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 Sybase Central or a 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.
• List the Remote Tables On a Server
  When configuring Sybase IQ, it is helpful to have access to a list of the remote tables available on a particular server.
• List Remote Server Capabilities
  The sp_servercaps procedure displays information about a remote server's capabilities. Sybase IQ uses this capability information to determine how much of a SQL statement can be passed to a remote server.