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.

Proxy Tables between two databases on the same dataserver

7 posts in General Discussion Last posting was on 2010-09-14 16:47:57.0Z
Susan L. Posted on 2010-09-13 08:46:14.0Z
Sender: 75d.4c8de43f.1804289383@sybase.com
From: Susan L.
Newsgroups: sybase.public.ase.general
Subject: Proxy Tables between two databases on the same dataserver
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c8de4d6.766.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Sep 2010 01:46:14 -0700
X-Trace: forums-1-dub 1284367574 10.22.241.41 (13 Sep 2010 01:46:14 -0700)
X-Original-Trace: 13 Sep 2010 01:46:14 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29553
Article PK: 78785

Hi Everyone,

I'm trying to create some proxy tables between two databases
on the same dataserver. Can this be done? Or does proxy
tables only work between two remote databases residing on
two separate dataservers?

Thank you,

Susan L.


Carl Kayser Posted on 2010-09-13 09:57:46.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4c8de4d6.766.1681692777@sybase.com>
Subject: Re: Proxy Tables between two databases on the same dataserver
Lines: 19
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8df59a$1@forums-1-dub>
Date: 13 Sep 2010 02:57:46 -0700
X-Trace: forums-1-dub 1284371866 10.22.241.152 (13 Sep 2010 02:57:46 -0700)
X-Original-Trace: 13 Sep 2010 02:57:46 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29554
Article PK: 78784


<Susan L.> wrote in message news:4c8de4d6.766.1681692777@sybase.com...
> Hi Everyone,
>
> I'm trying to create some proxy tables between two databases
> on the same dataserver. Can this be done? Or does proxy
> tables only work between two remote databases residing on
> two separate dataservers?
>
> Thank you,
>
> Susan L.

This is done on one of our databases via a remote server alias (e.g.,
loopback or the equivalent). I don't really see the benefit from an extra
layer of indirection. Perhaps it offers some flexibility in test
environments?


Jason L. Froebe [TeamSybase] Posted on 2010-09-13 10:55:44.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.12) Gecko/20100826 Thunderbird/3.0.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Proxy Tables between two databases on the same dataserver
References: <4c8de4d6.766.1681692777@sybase.com> <4c8df59a$1@forums-1-dub>
In-Reply-To: <4c8df59a$1@forums-1-dub>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8e0330@forums-1-dub>
Date: 13 Sep 2010 03:55:44 -0700
X-Trace: forums-1-dub 1284375344 10.22.241.152 (13 Sep 2010 03:55:44 -0700)
X-Original-Trace: 13 Sep 2010 03:55:44 -0700, vip152.sybase.com
Lines: 25
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29555
Article PK: 78786


On 09/13/2010 04:57 AM, Carl Kayser wrote:
> <Susan L.> wrote in message news:4c8de4d6.766.1681692777@sybase.com...
>> Hi Everyone,
>>
>> I'm trying to create some proxy tables between two databases
>> on the same dataserver. Can this be done? Or does proxy
>> tables only work between two remote databases residing on
>> two separate dataservers?
>>
>> Thank you,
>>
>> Susan L.
>
> This is done on one of our databases via a remote server alias (e.g.,
> loopback or the equivalent). I don't really see the benefit from an extra
> layer of indirection. Perhaps it offers some flexibility in test
> environments?
>
>

Or consolidation of multiple sybase servers into one where previously
access to the other tables were done via proxy tables.

jason


Carl Kayser Posted on 2010-09-13 12:35:12.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4c8de4d6.766.1681692777@sybase.com> <4c8df59a$1@forums-1-dub> <4c8e0330@forums-1-dub>
Subject: Re: Proxy Tables between two databases on the same dataserver
Lines: 16
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8e1a80$1@forums-1-dub>
Date: 13 Sep 2010 05:35:12 -0700
X-Trace: forums-1-dub 1284381312 10.22.241.152 (13 Sep 2010 05:35:12 -0700)
X-Original-Trace: 13 Sep 2010 05:35:12 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29556
Article PK: 78789

"Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com> wrote in message
news:4c8e0330@forums-1-dub...

(SNIP)

>
>
> Or consolidation of multiple sybase servers into one where previously
> access to the other tables were done via proxy tables.
>
> jason

Ahhhh, easy "upward compatibility" with respect to ASE consolidation on a
platform. OK.


Sherlock, Kevin [TeamSybase] Posted on 2010-09-13 20:32:47.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4c8de4d6.766.1681692777@sybase.com>
Subject: Re: Proxy Tables between two databases on the same dataserver
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8e8a6f$1@forums-1-dub>
Date: 13 Sep 2010 13:32:47 -0700
X-Trace: forums-1-dub 1284409967 10.22.241.152 (13 Sep 2010 13:32:47 -0700)
X-Original-Trace: 13 Sep 2010 13:32:47 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29557
Article PK: 78787

Proxy tables are really meant to access remote tables. Why aren't you
simply creating views instead, or better yet, using a fully qualified table
name to reference a table in a different database?

to answer the question: yes, you _can_ create a proxy table on a local
object. But, you can take a hammer and pound it into your hand. Why?

<Susan L.> wrote in message news:4c8de4d6.766.1681692777@sybase.com...
> Hi Everyone,
>
> I'm trying to create some proxy tables between two databases
> on the same dataserver. Can this be done? Or does proxy
> tables only work between two remote databases residing on
> two separate dataservers?
>
> Thank you,
>
> Susan L.


Bret Halford Posted on 2010-09-14 15:47:56.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.9) Gecko/20100825 Thunderbird/3.1.3
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Proxy Tables between two databases on the same dataserver
References: <4c8de4d6.766.1681692777@sybase.com> <4c8e8a6f$1@forums-1-dub>
In-Reply-To: <4c8e8a6f$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8f992c$1@forums-1-dub>
Date: 14 Sep 2010 08:47:56 -0700
X-Trace: forums-1-dub 1284479276 10.22.241.152 (14 Sep 2010 08:47:56 -0700)
X-Original-Trace: 14 Sep 2010 08:47:56 -0700, vip152.sybase.com
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29560
Article PK: 78790

The most common reasonable reason I come across is wanting to be
able to treat the output of a stored procedure as a table, where the
user cannot modify the stored procedure.

On 9/13/2010 2:32 PM, Sherlock, Kevin [TeamSybase] wrote:
> Proxy tables are really meant to access remote tables. Why aren't you
> simply creating views instead, or better yet, using a fully qualified table
> name to reference a table in a different database?
>
> to answer the question: yes, you _can_ create a proxy table on a local
> object. But, you can take a hammer and pound it into your hand. Why?
>
> <Susan L.> wrote in message news:4c8de4d6.766.1681692777@sybase.com...
>> Hi Everyone,
>>
>> I'm trying to create some proxy tables between two databases
>> on the same dataserver. Can this be done? Or does proxy
>> tables only work between two remote databases residing on
>> two separate dataservers?
>>
>> Thank you,
>>
>> Susan L.
>
>


Sherlock, Kevin [TeamSybase] Posted on 2010-09-14 16:47:57.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4c8de4d6.766.1681692777@sybase.com> <4c8e8a6f$1@forums-1-dub> <4c8f992c$1@forums-1-dub>
Subject: Re: Proxy Tables between two databases on the same dataserver
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c8fa73d$1@forums-1-dub>
Date: 14 Sep 2010 09:47:57 -0700
X-Trace: forums-1-dub 1284482877 10.22.241.152 (14 Sep 2010 09:47:57 -0700)
X-Original-Trace: 14 Sep 2010 09:47:57 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29561
Article PK: 78792

sure, and a good point. but i didn't see stored procedures mentioned in the
op.

"Bret Halford" <bret@sybase.com> wrote in message
news:4c8f992c$1@forums-1-dub...
> The most common reasonable reason I come across is wanting to be
> able to treat the output of a stored procedure as a table, where the
> user cannot modify the stored procedure.
>
> On 9/13/2010 2:32 PM, Sherlock, Kevin [TeamSybase] wrote:
>> Proxy tables are really meant to access remote tables. Why aren't you
>> simply creating views instead, or better yet, using a fully qualified
>> table
>> name to reference a table in a different database?
>>
>> to answer the question: yes, you _can_ create a proxy table on a local
>> object. But, you can take a hammer and pound it into your hand. Why?
>>
>> <Susan L.> wrote in message news:4c8de4d6.766.1681692777@sybase.com...
>>> Hi Everyone,
>>>
>>> I'm trying to create some proxy tables between two databases
>>> on the same dataserver. Can this be done? Or does proxy
>>> tables only work between two remote databases residing on
>>> two separate dataservers?
>>>
>>> Thank you,
>>>
>>> Susan L.
>>
>>
>