Loading remote data without native classes

You need to use DirectConnect to access remote data sources:

• On 64-bit UNIX platforms

• On 32-bit platforms where no ODBC driver is available (for example, Microsoft SQL Server)

This section and the following one provide examples of loading and querying data by means of DirectConnect.

For this example, assume that:

• An Enterprise Connect Data Access (ECDA) server named mssql exists on UNIX host myhostname, port 12530.

• The data is to be retrieved from an MS SQL server named 2000 on host myhostname, port 1433.

1. Using DirectConnect documentation, configure DirectConnect for your data source.

2. Make sure that ECDA server (mssql) is listed in the IQ interfaces file:

   mssql
   master tcp ether myhostname 12530
   query tcp ether myhostname 12530
   

3. Add a new user, using the user id and password for server mssql:

   isql -Udba -Psql -Stst_iqdemo
   grant connect to chill identified by chill
   grant dba to chill
   

4. Log in as the new user to create a local table on IQ:

   isql -Uchill -Pchill -Stst_iqdemo
   create table billing(status char(1), name varchar(20), telno int)
   

5. Insert data:

   insert into billing location ‘mssql.pubs’ { select * from billing }