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.

Multiple database

2 posts in PB Infomaker Report Writer Last posting was on 1998-10-29 19:58:48.0Z
Pete Prada Posted on 1998-10-29 15:19:58.0Z
Newsgroups: sybase.public.infomaker.general
From: "Pete Prada" <pete@saionline.com>
Subject: Multiple database
Date: Thu, 29 Oct 1998 09:19:58 -0600
Lines: 3
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <348_CVgb2V0A#GA.288@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6798
Article PK: 242828

Can i be able to use multiple database to create 1 report?


Terry Dykstra [TeamPS] Posted on 1998-10-29 19:58:48.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Multiple database
Date: Thu, 29 Oct 1998 12:58:48 -0700
Lines: 23
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_0CXHmy2A#GA.271@forums.powersoft.com>
References: <348_CVgb2V0A#GA.288@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6796
Article PK: 242829

Generally speaking, no. If your database allows you to create links, then
you can (e.g. Oracle).
If you use Sybase, then I believe it is possible:

You have to use syntax mode but you should be able to select from two
databases if they're on the same server.

Select database1..table.column, database2..table2.column2 from
database1..table, database2..table2

This is code I got from somebody else, so I'm not sure if it works. I use
Oracle only.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Pete Prada wrote in message ...
>Can i be able to use multiple database to create 1 report?
>
>