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     [CLOSED] Who knows what the field RELNAME in SYSCOLUM is for?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Who knows what the field RELNAME in SYSCOLUM is for?
 Login/Join
 
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: 62 | Location: reading, pa | Registered: April 07, 2007Reply With QuoteReport This Post
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: 1905 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
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: 62 | Location: reading, pa | Registered: April 07, 2007Reply With QuoteReport This Post
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: 1905 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.