PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Gang_Liu/Systems/Central/SunLife at SunLifeOfCanada dot com
Subject: Re: Create View of a table on another host
Date: Jul 2 1999 8:21PM

Using CIS which comes with ASE 11.5,  you can do it.




jrisley@nex-web4.corp.fedex.com (Jason Risley) on 99/07/02 03:26:45 PM

Please respond to jrisley@fedex.com

To:   SybPerl Discussion List 
cc:    (bcc: Gang Liu/Systems/Central/SunLife)
Subject:  Create View of a table on another host




All,

Has anyone done the following and/or could assist in creating the following
scenario?

On Host_1:
  a. DB_Server_1
  b. DB_1
  c. Table_1 is a view of:
     1) On Host_2:
        a) DB_Server_2
        b) DB_2
        c) Table_2

In lay terms, one database has a view of a table contained in another
database on another host.

Any assistance is greatly appreciated!
Thanks
Jason