To insert from an Adaptive Server database to a Sybase IQ database, or to create a simple connection using iqisql, each server must have an entry in the interfaces file on the client computer. Interfaces file entries, also called server objects, also simplify database startup.
Use iqdsedit (IQ Directory Services Editor) to create entries in the interfaces file. You must be the owner of the Sybase home directory ($SYBASE) in order to run iqdsedit. See “Configuring IQ servers with DSEDIT” in Chapter 15, “Sybase IQ as a Data Server,” in the Sybase IQ System Administration Guide.
Sybase IQ 15.2 includes a simplified version
of the TDS tools iqdsedit and iqisql.
To use advanced features, like encrypted connections, you will need the
full version included with Adaptive Server or Replication Server.
The iqdsedit utility lets you view and edit server entries in the interfaces file. Make a copy of the interfaces file before you make any changes.
Start the Open Client Directory Service Editor:
% $IQDIR15/bin64/iqdsedit
On the Directory Service dialog, click OK.
On the Directory Service Session dialog, click Add new server entry.
On the Server Entry Editor, type the server name, then click Add new network transport. The server name in your iqdsedit entry must be the same as the database name.
On the Network Transport Editor, select TCP transport, then enter the host name and port number. The defaults are usually sufficient.
Click OK to return to the Server Entry Editor. The server is now listed under Available Network Transports.
Adding a server object