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] Who knows what the field RELNAME in SYSCOLUM is for?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Who knows what the field RELNAME in SYSCOLUM is for?
 Login/Join
 
jnc
Gold member
posted
I am chasing down some performance issue and have noticed in the SYSCOLUMN master that I have an extraordinary number of records for the RELNAME field in SYSCOLUM

Does anyone know what this field is for, how it gets there, how it's used, and why would I have so many records?

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


WebFocus 7x, 8x, Win / Linux, any output format
 
Posts: 70 | Location: reading, pa | Registered: April 07, 2007Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
jnc

I have never paid attention to this field before but it is labeled related field name. If you run this query below it shows all the fields related to each field in a master file. In the case with the car file it shows all fields in the hierarchy of the focus table. Look at the WARRANTY field vs DEALER_COST

TABLE FILE SYSCOLUM
PRINT RELNAME
BY TBNAME
BY NAME
WHERE TBNAME EQ 'CAR'
ON TABLE PCHOLD FORMAT HTML
END


I would avoid using this field in a report against syscolum it would return a lot of data.

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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
jnc
Gold member
posted Hide Post
Hello Chuck,

Ok, that is interesting.

Is there a way to find out if it is used anywhere?

I ran your example and see that 20 fields turns into 334 lines of output. I see now how they are related. Can you provide any insight or explanation how they are used?

I see it as a clear example why the PATH should be kept as short as possible because 1 master turns into 334 data points. We have 400M values of RELNAME in syscolum and I think it's slowing down something. (because it takes a while to read 400M records)

Any insight when and where RELNAME is actually used?


WebFocus 7x, 8x, Win / Linux, any output format
 
Posts: 70 | Location: reading, pa | Registered: April 07, 2007Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
JNC

I think the only way to find that out is to open a case with techsupport.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report 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] Who knows what the field RELNAME in SYSCOLUM is for?

Copyright © 1996-2020 Information Builders