I know how to use CHECK FILE HOLD to get a list of segments and fields, however some information is missing like REMARKS, segment description. Also primary key and index information, and join information for relational tables.

I'm using WebFOCUS version 81M.

Is there another query that I can use to get that kind of information? Perhaps one of the APP queries? I use "APP LIST HOLD" to get a list of files in the APP folders.

Thanks,
Sharon

This message has been edited. Last edited by: <Kathryn Henning>,

You can probably get this info from SYSCOLUM.
Please research SYSCOLUM.

I cannot find the SYSCOLUMN master. It isn't in baseapp or ibisamp app folders. I wonder if it exists in WF8? I noticed the article in your link is from 2009.

I also tried to find a table in the WF8_CORE db but did not find anything really useful. There could be a stored procedure, but it isn't clear from the names if they are useful for my situation.

Thanks,
Sharon

quote:

SYSCOLUMN

Try it without the "N" and you will find it

Remember that it is multi segment and some segments may not contain data so you may want to use SET ALL=PASS

T

Great Scott! I missed something. I just tried without the N and there it was!

Thanks!

The devil's in the detail!!

T

There is also a SYSAPPS master that contains detail information on all files in the APP folders as well as app folder info. The REMARKS from the FILE line in the master is located there.

And also SYSTABLE as well as others.

And don't forget the RDBMS system tables...