Focal Point
[CLOSED] Synonym Question

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

December 11, 2018, 11:27 AM
Steven L Carter
[CLOSED] Synonym Question
When creating a synonym, is there an equivalent to the MORE command used in fex files? In other words, I want to create a new synonym from two existing synonyms. The existing synonyms have the same fields but different data sources. I want my new synonym to have the same number of fields as the existing synonyms but contain the data from both.

How do I go about doing that?

All advice appreciated. Thanks.
STEVE

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8201
Excel, PDF, HTML
December 11, 2018, 12:57 PM
BabakNYC
So you want to concatenate the two identical data structures? What's the DBMS?


WebFOCUS 8206, Unix, Windows
December 11, 2018, 01:27 PM
Steven L Carter
One source is an Oracle table and the other is an imported Excel file.


WebFOCUS 8201
Excel, PDF, HTML
December 11, 2018, 01:35 PM
BabakNYC
I doubt you can create a single synonym that does that. The first thing that comes to mind is to create two reports that extract the columns you want and HOLD FORMAT FOCUS. Then apply USE command to virtually concatenate the two hold files.


WebFOCUS 8206, Unix, Windows
December 14, 2018, 01:55 PM
NewBee...WF8
quote:
Originally posted by Steven L Carter:
One source is an Oracle table and the other is an imported Excel file.


You can create a Synonym off of the imported excel file and join both

oracle table and synonym from the excel. I have done it and it works fine.

Thanks


WebFOCUS 8
Windows, All Outputs
December 14, 2018, 02:11 PM
Doug
Once you have two JOINable synonyms, you should be able to create a 'Clustered Synonym' from that.
December 14, 2018, 08:14 PM
BabakNYC
I think Steve wants to concatenate the two tables not join them.


WebFOCUS 8206, Unix, Windows
December 17, 2018, 08:14 AM
Steven L Carter
Correct. If I were just writing a request, it would be the MORE command I would use. But since we are talking master files, I'm not sure how to (or if it is even possible to) proceed.


WebFOCUS 8201
Excel, PDF, HTML
December 17, 2018, 10:18 AM
FP Mod Chuck
Steve

I thought Babak's idea of creating 2 FOCUS hold files and then the USE command for concatenating them was brilliant and a solid answer to your problem.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats