Setting up SAP Sybase IQ to Connect to the Adaptive Server Enterprise Server

Follow these steps to query Adaptive Server Enterprise data.

1. Add an entry to the SAP Sybase IQ interfaces file:

   jones_1207
   master tcp ether jones 4101
   query tcp ether jones 4101

2. Create the user to connect to Adaptive Server Enterprise:

   GRANT CONNECT TO tst IDENTIFIED BY tsttst
   GRANT dba TO tst

3. Log in as the added user to create the 'asejdbc' server class and add external login:

   isql -Utst -Ptsttst -Stst_iqdemo
   CREATE SERVER jones_1207 CLASS 'asejdbc' USING 'jones:4101/tst_db'
   CREATE EXISTING TABLE billing_iq AT 'jones_1207.tst_db..billing_txt' 
   SELECT * from billing_iq

   status				name          telno
   ------    -----------   -----
   D         BOTANICALLY   1
   B         BOTANICALL    2
   (2 rows affected)