Re: MSSQL 7.0 overview ...

Ng K C Paul wrote in message <72bt4i$mt4$1_at_imsp009a.netvigator.com>...
>What is the best method in Sybase to implement like Oracle Server/Database
>Link?

My opinion - if you have a gateway into the foreign database, and you can access the foreign tables via a database link then: CREATE TABLE localtable
STORAGE ( whatever)
UNRECOVERABLE AS
SELECT * FROM foreigntable_at_databaselink

You thus pull the data across for local processing. If there's some data scrubbing or conversion involved, then you can get creative with the SELECT part of the above statement, using NVL, DECODE and other functions to convert the columns to whatever you would like.

Once the above table is created, use it for joining to other tables to do whatever processing is required for that data set in your local database.

If you don't have a gateway, then you will have to resort to less elegant methods of data transfer - like using bulk unloading, FTP and so on. The biggest problem with this (when done on NT) is the lack of a good shell script language. On Unix there are some nice solutions like using pipes to run FTP and SQL*Load in parallel for example.

regards,
Billy Received on Wed Nov 11 1998 - 00:00:00 CST