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.

Reports using multiple databases

3 posts in PB Infomaker Report Writer Last posting was on 1997-12-03 23:07:47.0Z
Kathy Champagne Posted on 1997-12-02 23:52:40.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 02 Dec 1997 17:52:40 -0600
From: Kathy Champagne <kathy@aol.com>
Reply-To: kathy@aol.com
Organization: OHA Financial, Inc.
X-Mailer: Mozilla 3.03Gold (WinNT; I)
MIME-Version: 1.0
Subject: Reports using multiple databases
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 8
Message-ID: <348_34849F48.52FF@aol.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7376
Article PK: 244433

My company has 2 databases that reside on the same SQL 6.5 server. Is it
possible to create a report in InfoMaker that will draw information from
tables in both databases? And if so, how? And if not, is that something
that is planned?

Thanks!
Kathy Champagne
OHA Financial, Inc.


Terry Dykstra Posted on 1997-12-03 23:07:47.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Reports using multiple databases
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Wed, 03 Dec 1997 18:07:47 -0500
Lines: 16
Message-ID: <348_01bd0048$aa183380$8366e4cf@tdykstra.cfol.ab.ca>
References: <348_34849F48.52FF@aol.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7367
Article PK: 244423

I'm not familiar with SQL Server, but in Oracle you can create a database
link that allows you to access a database from another database. I would
think that SQL Server has a similar capability.

Terry Dykstra (TeamPS)

Kathy Champagne <kathy@aol.com> wrote in article <34849F48.52FF@aol.com>...
> My company has 2 databases that reside on the same SQL 6.5 server. Is it
> possible to create a report in InfoMaker that will draw information from
> tables in both databases? And if so, how? And if not, is that something
> that is planned?
>
> Thanks!
> Kathy Champagne
> OHA Financial, Inc.
>


Eva Maciasz Posted on 1997-12-03 15:53:29.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 03 Dec 1997 10:53:29 -0500
From: Eva Maciasz <emacia@po-box.mcgill.ca>
Organization: McGill University, Montreal, Canada
X-Mailer: Mozilla 3.0Gold (Win95; I)
MIME-Version: 1.0
To: kathy@aol.com
Subject: Re: Reports using multiple databases
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
Message-ID: <348_34858079.51AF@po-box.mcgill.ca>
References: <348_34849F48.52FF@aol.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7373
Article PK: 244430


Kathy Champagne wrote:
>
> My company has 2 databases that reside on the same SQL 6.5 server. Is it
> possible to create a report in InfoMaker that will draw information from
> tables in both databases? And if so, how? And if not, is that something
> that is planned?
>
> Thanks!
> Kathy Champagne
> OHA Financial, Inc.

In my opinion you can do it only by designing application in
Powerbuilder, but you cannot create a report in Infomaker which will
fetch for the data from two different data sources.
Infomaker connects to the database and runs a report in the current
instance, in order to use another database you have to run the second
instance of the same report but you cannot use two different databases
at the same time 'cause data source must be specified before the report
starts.
Greetings,