You must issue a separate CREATE SERVER statement for each remote SAP Sybase IQ database you intend to access. For example, if an 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.