Loading MS SQL Server Data into an SAP Sybase IQ Server on UNIX

This remote data example loads MS SQL Server data into an SAP Sybase IQ server on UNIX.

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.

Using DirectConnect documentation, configure DirectConnect for your data source.
Make sure that ECDA server (mssql) is listed in the SAP Sybase IQ interfaces file:
```
mssql
master tcp ether myhostname 12530
query tcp ether myhostname 12530
```

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

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

Insert data:

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