Focal Point
[CASE-OPENED] Creating a cluster synonym using synonyms from two different databases

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4347049276

October 03, 2014, 03:10 PM
Michellelp
[CASE-OPENED] Creating a cluster synonym using synonyms from two different databases
Hi All,

I am trying to create a cluster synonym using synonyms from one database and joing them to another clustered synonym in a different database. Is this possible and if so what is the best way for it to be done? I've tried by starting with one synonym and joining it to a reference of the clustered synonym. I tested this by trying to create a report off my newly created cluster synonym and I got a parsing error. Any help would be appreciated.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.1.05
Windows, All Outputs
October 08, 2014, 06:42 PM
<Kathryn Henning>
Hi Michellelp,

Welcome to Focal Point!

I see that you've opened a case and are working with Customer Support with your files. Please keep us updated on the outcome.

For others who may find this topic, here is an example of joining two clustered synonyms. Please note that you will need to be logged into InfoResponse Online to view the link.

Can Cluster files be JOINed?

Cheers!

Kathryn