Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] creating single master file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] creating single master file
 Login/Join
 
<swapna>
posted
i have two tables and i need to create a single master file with these two tables without joining them. Is this possible??? pls suggest

This message has been edited. Last edited by: Kerry,
 
Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Swapna,

1. Do you mean that the files are disjointed: have nothing in common? Or, do you want then to be joined within the master file?
2. You say "tables". Are these SQL tables?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
<swapna>
posted
these are oracle tables and they do not have common fields....
i need not join those tables...
without joining is it possible to create a single master field....
 
Report This Post
<JG>
posted
quote:
do not have common fields

Why do you need a single master when there is no logical relationship between the tables, it makes no sense at all.
 
Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Swapna,

If you have to keep the original Oracle tables, I don't know of a method. However, if you don't mind loading the data into a FOCUS file, then, it is possible. However, these will be unrelated segments, so don't try to sort data of one table by a field in the other...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Danny-SRL
Virtuoso
posted Hide Post
JG,

Remember in the old days there used to be sequential files with unrelated data so a DUMMY segment was put into use.

Possibly, they want to have one MASTER to present to some users who can then decide to report, say, on the employees OR on the purchase orders.

I agree that it is abit strange...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
GamP
Virtuoso
posted Hide Post
There is only one way to have two tables defined in one master file, and that is if the two tables are linked by some common field. If they do not have at least one field in common, you can't put both tables in one master file.
In short: you have to be able to join them in order to create one mfd for them.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Gerard,

This is true for SQL tables. A hierarchy MUST be defined.

However, if it is an absolute necessity to have ONE master for TWO or more independant tables you can load them into a FOCUS file:
  
FILENAME=SWAPNA, SUFFIX=FOC
SEGNAME=DUM, SEGTYPE=S1
 FIELDNAME=DUM, ALIAS=DUM, USAGE=A1, $
SEGNAME=TABLE1, SEGTYPE=ss, PARENT=DUM
 FIELDNAME=....
 ....
SEGNAME=TABLE2, SEGTYPE=ss, PARENT=DUM
 FIELDNAME=....
 ....


And you load the data from the original tables. A bit strange, but it will work.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] creating single master file

Copyright © 1996-2020 Information Builders