You must issue a separate CREATE SERVER statement for each remote SAP Sybase IQ database you intend to access. For example, if a SAP Sybase IQ server named TestSA is running on the computer Banana and owns three databases (db1, db2, db3), you would set up the remote servers similar to this:
CREATE SERVER TestSAdb1 CLASS 'SAODBC' USING 'DRIVER=Sybase IQ;HOST=Banana;Server=TestSA;DBN=db1'; CREATE SERVER TestSAdb2 CLASS 'SAODBC' USING 'DRIVER=Sybase IQ;HOST=Banana;Server=TestSA;DBN=db2'; CREATE SERVER TestSAdb3 CLASS 'SAODBC' USING 'DRIVER=Sybase IQ;HOST=Banana;Server=TestSA;DBN=db3';
If you do not specify a database name, the remote connection uses the remote SAP Sybase IQ server default database.