If you need to insert from an Adaptive Server Enterprise database to a Sybase IQ database, or you want 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. For more about 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.0 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 ASE, SDK, or Replication Server.
The iqdsedit utility lets you view and edit server entries in the interfaces file using a GUI based on X11/Motif in UNIX platforms. Be sure to make a copy of the interfaces file before you make any changes.
Start the Open Client Directory Service Editor.
% $IQDIR15/bin64/iqdsedit
The default interfaces file and configuration file display.
Click OK to continue or Exit to quit.
Select Add new server entry.
Type the server name and click Add new network transport. The server name in your iqdsedit entry must be the same as the database name.
Select the TCP transport and enter the host name and port number. (The defaults are usually sufficient.) Click OK.
Click OK.
The server is now listed under Available servers.
Click Close session to make new server entries usable.
Click Exit to close iqdsedit.
Click Yes to “Are you sure you want to exit iqdsedit?”
Adding a server object