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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Stumped by defines!
 Login/Join
 
<elina>
posted
Hi, all -

I'm very new to this WebFOCUS business and I'm trying to do something that may not even make sense. Maybe somebody can clue me in.

I'm using the report painter. In my project I have a define for a field in one table. This is followed by a four-way join based on the same table. In the join view I can see the defined field, however when I open a report the defined field is not in the list.

Should I be creating a HOLD file before I make my join? Where am I going wrong?

Thanks for your help!
 
Report This Post
Jen
Gold member
posted Hide Post
Hi Elina,

What you're trying to do makes total sense! Did you run your join before opening the Report Painter? That's the only thing I can think of, especially since you see the defined field in the Join view.
 
Posts: 68 | Location: Springfield MA | Registered: May 07, 2003Report This Post
Chris Boylan
Gold member
posted Hide Post
JOIN clears DEFINEs so you need to make sure that the DEFINE is executed AFTER the JOIN (which always seemed strange to me... particularly with DEFINE-based JOINs). Run the JOIN first, then the DEFINE and then you should see the defined field in the painter

You can also place the DEFINE in the Master File Description to avoid this problem.

Hope that helps...

-Chris
 
Posts: 55 | Location: New York | Registered: March 07, 2003Report This Post
<kj>
posted
The JOIN command clears all defined fields.
To preserve the virtual fields after join, you need to set the KEEPDEFINES SET command on.
Place it before you define virtual fields.

SET KEEPDEFINES = ON

Thanks,
kj
 
Report This Post
<elina>
posted
Thanks for your help, guys! At least now I know how the defines work with joins.

quote:
Originally posted by kj:
[qb] The JOIN command clears all defined fields.
To preserve the virtual fields after join, you need to set the KEEPDEFINES SET command on.
Place it before you define virtual fields.

SET KEEPDEFINES = ON

Thanks,
kj [/qb]
Thanks, kj. I put in the SET as you suggested and it allows the defined field to stay in the list. Unfortunately there's another problem now which breaks my report, but I don't think it has anything to do with the join. My defined field references two fields from two different tables but after the join the defined field is not listed at the bottom of the join but inside one of the tables. What could I do to fix that?

Thanks again!
 
Report This Post
webfocuspgm
Platinum Member
posted Hide Post
My issue is something like this one only I need to create a "reporting object" joining two tables on a field that is a different size in each table.

How do you create a defined base join for a reporting object in MRE ..... I'm not using Report Painter...... Is it possible...?

Thanks
 
Posts: 132 | Location: Kansas | Registered: November 12, 2003Report This Post
<Emma Schwarz>
posted
When you're creating a Reporting Object, the JOIN component is created before the DEFINE component, so you can't use an inline DEFINE. It sounds like you're better off using a DEFINE in the Master. You need to put the DEFINE in the Master file you're JOINing FROM (the first Master in the JOIN statement, and the one you specified when you created the Reporting Object).

Hope this helps.
Emma
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders