Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Linked Server in Sybase ASE

3 posts in General Discussion Last posting was on 2010-02-23 08:23:51.0Z
Santhanam P Posted on 2010-02-22 14:08:32.0Z
Sender: 1c83.4b828b77.1804289383@sybase.com
From: Santhanam P
Newsgroups: sybase.public.ase.general
Subject: Linked Server in Sybase ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b828fe0.1d7b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Feb 2010 06:08:32 -0800
X-Trace: forums-1-dub 1266847712 10.22.241.41 (22 Feb 2010 06:08:32 -0800)
X-Original-Trace: 22 Feb 2010 06:08:32 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28990
Article PK: 78228

Hi,
I have to query the data from different database server from
one database server. Is there any possible ways to query the
data. is there any way to create a linked server in Sybase
ASE. If it is please provide the details.
Thanks in advance :-)


Sherlock, Kevin [TeamSybase] Posted on 2010-02-22 15:42:00.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4b828fe0.1d7b.1681692777@sybase.com>
Subject: Re: Linked Server in Sybase ASE
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b82a5c8@forums-1-dub>
Date: 22 Feb 2010 07:42:00 -0800
X-Trace: forums-1-dub 1266853320 10.22.241.152 (22 Feb 2010 07:42:00 -0800)
X-Original-Trace: 22 Feb 2010 07:42:00 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28991
Article PK: 78229

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32702.1502/html/omni_ug/title.htm

<Santhanam P> wrote in message news:4b828fe0.1d7b.1681692777@sybase.com...
> Hi,
> I have to query the data from different database server from
> one database server. Is there any possible ways to query the
> data. is there any way to create a linked server in Sybase
> ASE. If it is please provide the details.
> Thanks in advance :-)


PDreyer Posted on 2010-02-23 08:23:51.0Z
Sender: 4317.4b837cec.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Re: Linked Server in Sybase ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b839097.4547.1681692777@sybase.com>
References: <4b828fe0.1d7b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Feb 2010 00:23:51 -0800
X-Trace: forums-1-dub 1266913431 10.22.241.41 (23 Feb 2010 00:23:51 -0800)
X-Original-Trace: 23 Feb 2010 00:23:51 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28992
Article PK: 78230


> Hi,
> I have to query the data from different database server
> from one database server. Is there any possible ways to
> query the data. is there any way to create a linked server
> in Sybase ASE. If it is please provide the details.
> Thanks in advance :-)

Transact-SQL
create existing table - Creates a proxy table, then
retrieves and stores
metadata from a remote table and places the data
into the proxy
table. Allows you to map the proxy table to a
table, view, or
procedure at a remote location.
create existing table table_name (column_list)
[ on segment_name ]
[ [ external {table | procedure} ] at pathname ]