![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Member |
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. STEVEThis message has been edited. Last edited by: FP Mod Chuck, WebFOCUS 8201 Excel, PDF, HTML | ||
|
Virtuoso |
So you want to concatenate the two identical data structures? What's the DBMS? WebFOCUS 8206, Unix, Windows | |||
|
Member |
One source is an Oracle table and the other is an imported Excel file. WebFOCUS 8201 Excel, PDF, HTML | |||
|
Virtuoso |
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 | |||
|
Gold member |
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 | |||
|
Expert |
Once you have two JOINable synonyms, you should be able to create a 'Clustered Synonym' from that. | |||
|
Virtuoso |
I think Steve wants to concatenate the two tables not join them. WebFOCUS 8206, Unix, Windows | |||
|
Member |
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 | |||
|
Virtuoso |
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 | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|