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.

DBlink like concept in sybase

6 posts in Cluster Last posting was on 2012-05-30 04:50:14.0Z
Shrikant suryawanshi Posted on 2009-04-02 11:41:27.0Z
Sender: fdc.49d4a18e.1804289383@sybase.com
From: Shrikant suryawanshi
Newsgroups: sybase.public.ase.cluster
Subject: DBlink like concept in sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49d4a467.102e.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Apr 2009 03:41:27 -0800
X-Trace: forums-1-dub 1238672487 10.22.241.41 (2 Apr 2009 03:41:27 -0800)
X-Original-Trace: 2 Apr 2009 03:41:27 -0800, 10.22.241.41
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:125
Article PK: 48407

I would be very helpful if I got a solution on my question
Example : In MSSQL we use DBlink concept to access remote
Data from another MSSQL server

Like that if we have Sybase ASE 15.0.2 install on ‘A’
machine and also on ‘B’ machine. [sybase-to-sybase]
Now how would we access data from [A] of [B].
Here we use single select query of join [here A will local
and B will remote.]

Please without using proxy table can we use it ..
Can we access A & b table in one select query which can be
executed from [A] server

We provide objectname.ownername.tablename for local A
server

And for other dblink. objectname.ownername.tablename

select * from
A.dbo.tabnm[A],linkNM.dbNM[B].ownerNM[B].tabNM[B] ;
--localserver A , -- other server B


please need your views

if it not possible then tell the possible solution where we
can access data from local and remote in one query…

mail solution on shri6772@gmail.com or here too


J Posted on 2009-04-02 15:01:01.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: DBlink like concept in sybase
Reply-To: J@bogusemailAddress.com
Message-ID: <49d4d221.763628@forums.sybase.com>
References: <49d4a467.102e.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 2 Apr 2009 07:01:01 -0800
X-Trace: forums-1-dub 1238684461 10.22.241.152 (2 Apr 2009 07:01:01 -0800)
X-Original-Trace: 2 Apr 2009 07:01:01 -0800, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:126
Article PK: 48408

On 2 Apr 2009 03:41:27 -0800, Shrikant suryawanshi wrote:

This is the wrong newsgroup for this post. This newsgroup is for
questions related to the Adaptive Server Cluster Edition Product.

I would reply briefly that CIS proxy tables are normal way to do cross
system queries. Since I don't know DBlink concept I will not comment
further.

J

>I would be very helpful if I got a solution on my question
>Example : In MSSQL we use DBlink concept to access remote
>Data from another MSSQL server
>
>Like that if we have Sybase ASE 15.0.2 install on =91A=92
>machine and also on =91B=92 machine. [sybase-to-sybase]
>Now how would we access data from [A] of [B].
>Here we use single select query of join [here A will local
>and B will remote.]
>
>Please without using proxy table can we use it ..
>Can we access A & b table in one select query which can be
>executed from [A] server
>
>We provide objectname.ownername.tablename for local A
>server
>
>And for other dblink. objectname.ownername.tablename
>
>select * from
>A.dbo.tabnm[A],linkNM.dbNM[B].ownerNM[B].tabNM[B] ;
> --localserver A , -- other server B
>
>
>please need your views
>
>if it not possible then tell the possible solution where we
>can access data from local and remote in one query=85
>
>mail solution on shri6772@gmail.com or here too


M Paul Posted on 2009-04-16 22:20:08.0Z
Sender: 77eb.49e7ae21.1804289383@sybase.com
From: M Paul
Newsgroups: sybase.public.ase.cluster
Subject: Re: DBlink like concept in sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49e7af18.781a.1681692777@sybase.com>
References: <49d4a467.102e.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Apr 2009 15:20:08 -0700
X-Trace: forums-1-dub 1239920408 10.22.241.41 (16 Apr 2009 15:20:08 -0700)
X-Original-Trace: 16 Apr 2009 15:20:08 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:132
Article PK: 48414

Please try using CIS rpc selects

> I would be very helpful if I got a solution on my question
> Example : In MSSQL we use DBlink concept to access remote
> Data from another MSSQL server
>
> Like that if we have Sybase ASE 15.0.2 install on ‘A’
> machine and also on ‘B’ machine. [sybase-to-sybase]
> Now how would we access data from [A] of [B].
> Here we use single select query of join [here A will local
> and B will remote.]
>
> Please without using proxy table can we use it ..
> Can we access A & b table in one select query which can be
> executed from [A] server
>
> We provide objectname.ownername.tablename for local A
> server
>
> And for other dblink. objectname.ownername.tablename
>
> select * from
> A.dbo.tabnm[A],linkNM.dbNM[B].ownerNM[B].tabNM[B] ;
> --localserver A , -- other server B
>
>
> please need your views
>
> if it not possible then tell the possible solution where
> we can access data from local and remote in one query…
>
> mail solution on shri6772@gmail.com or here too


1111111111111111 Posted on 2010-06-25 02:36:10.0Z
Sender: 34f1.4c2414d0.1804289383@sybase.com
From: 1111111111111111
Newsgroups: sybase.public.ase.cluster
Subject: Re: DBlink like concept in sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c24161a.3518.1681692777@sybase.com>
References: <49d4a467.102e.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Jun 2010 19:36:10 -0700
X-Trace: forums-1-dub 1277433370 10.22.241.41 (24 Jun 2010 19:36:10 -0700)
X-Original-Trace: 24 Jun 2010 19:36:10 -0700, 10.22.241.41
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:206
Article PK: 48484


> I would be very helpful if I got a solution on my question
> Example : In MSSQL we use DBlink concept to access remote
> Data from another MSSQL server
>
> Like that if we have Sybase ASE 15.0.2 install on ‘A’
> machine and also on ‘B’ machine. [sybase-to-sybase]
> Now how would we access data from [A] of [B].
> Here we use single select query of join [here A will local
> and B will remote.]
>
> Please without using proxy table can we use it ..
> Can we access A & b table in one select query which can be
> executed from [A] server
>
> We provide objectname.ownername.tablename for local A
> server
>
> And for other dblink. objectname.ownername.tablename
>
> select * from
> A.dbo.tabnm[A],linkNM.dbNM[B].ownerNM[B].tabNM[B] ;
> --localserver A , -- other server B
>
>
> please need your views
>
> if it not possible then tell the possible solution where
> we can access data from local and remote in one query…
>
> mail solution on shri6772@gmail.com or here too


walmir.taques Posted on 2012-05-29 17:55:00.0Z
Sender: 4eaa.4fc50c24.1804289383@sybase.com
From: walmir.taques
Newsgroups: sybase.public.ase.cluster
Subject: Re: DBlink like concept in sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fc50d74.4ee0.1681692777@sybase.com>
References: <49d4a467.102e.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 May 2012 10:55:00 -0700
X-Trace: forums-1-dub 1338314100 172.20.134.41 (29 May 2012 10:55:00 -0700)
X-Original-Trace: 29 May 2012 10:55:00 -0700, 172.20.134.41
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:251
Article PK: 48529


> I would be very helpful if I got a solution on my question
> Example : In MSSQL we use DBlink concept to access remote
> Data from another MSSQL server
>
> Like that if we have Sybase ASE 15.0.2 install on ‘A’
> machine and also on ‘B’ machine. [sybase-to-sybase]
> Now how would we access data from [A] of [B].
> Here we use single select query of join [here A will local
> and B will remote.]
>
> Please without using proxy table can we use it ..
> Can we access A & b table in one select query which can be
> executed from [A] server
>
> We provide objectname.ownername.tablename for local A
> server
>
> And for other dblink. objectname.ownername.tablename
>
> select * from
> A.dbo.tabnm[A],linkNM.dbNM[B].ownerNM[B].tabNM[B] ;
> --localserver A , -- other server B
>
>
> please need your views
>
> if it not possible then tell the possible solution where
> we can access data from local and remote in one query…
>
> mail solution on walmir.taques@gmail.com or here too


Michael Peppler [Team Sybase] Posted on 2012-05-30 04:50:14.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: DBlink like concept in sybase
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2012.05.30.04.51.28.579780@peppler.org>
Newsgroups: sybase.public.ase.cluster
References: <49d4a467.102e.1681692777@sybase.com> <4fc50d74.4ee0.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 29 May 2012 21:50:14 -0700
X-Trace: forums-1-dub 1338353414 10.22.241.152 (29 May 2012 21:50:14 -0700)
X-Original-Trace: 29 May 2012 21:50:14 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:252
Article PK: 48532

Hi,

No, I don't think you could do this without proxy tables, unless you
installed ASE Cluster Edition, but that's a whole different animal.

Michael

On Tue, 29 May 2012 10:55:00 -0700, walmir.taques wrote:

>> I would be very helpful if I got a solution on my question Example : In
>> MSSQL we use DBlink concept to access remote Data from another MSSQL
>> server
>>
>> Like that if we have Sybase ASE 15.0.2 install on ‘A’ machine and also
>> on ‘B’ machine. [sybase-to-sybase] Now how would we access data from
>> [A] of [B]. Here we use single select query of join [here A will local
>> and B will remote.]
>>
>> Please without using proxy table can we use it .. Can we access A & b
>> table in one select query which can be executed from [A] server
>>
>> We provide objectname.ownername.tablename for local A server
>>
>> And for other dblink. objectname.ownername.tablename
>>
>> select * from
>> A.dbo.tabnm[A],linkNM.dbNM[B].ownerNM[B].tabNM[B] ;
>> --localserver A , -- other server B
>>
>>
>> please need your views
>>
>> if it not possible then tell the possible solution where we can access
>> data from local and remote in one query…
>>
>> mail solution on walmir.taques@gmail.com or here too