Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Do you lose master file Defines when you join?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Do you lose master file Defines when you join?
 Login/Join
 
Virtuoso
posted
I know you lose Defines when you use a table in a join, i.e., Defines created earlier in the focexec.

Question -- do you lose the Defines created in the master file? I'm not in a position to test that right now.

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



 
Posts: 995 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hi John

I created a DEFINE in a fact table and joined it to a dimension table and the DEFINE was available for me to use when creating a report with App Studio.

Hope this helps you...


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2050 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
It does, thanks.

I have a huge text field that parses into 200 separate fields, so having all the parses in the master files makes it super-easy to use everywhere.



 
Posts: 995 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Master
posted Hide Post
I use DEFINES in masters all the time. They may go away with a JOIN CLEAR *, but as soon as you reference the master file again, they are back. Also, something I'm pretty sure was fixed a number of years ago, is that if you use the master in a recursive JOIN and use the TAG attribute the DEFINE respects the TAG now. When they first came out with putting DEFINEs in master, FOCUS/WebFOCUS would get all confused when referencing a DEFINEd field in a recursive JOIN.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 970 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Do you lose master file Defines when you join?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.