DICTVOC

asoka_dwh · Post by **asoka_dwh** » Wed Sep 20, 2006 4:19 am

Can anybody explain what is DICTVOC.

Xpert · Post by **Xpert** » Wed Sep 20, 2006 4:34 am

asoka_dwh wrote:Can anybody explain what is DICTVOC.

Hi ashok,

DICT means Dictionary and VOC means Vocabulary. If anything mistake please legends correct me.

kduke · Post by **kduke** » Wed Sep 20, 2006 7:37 am

You are correct. These are concepts within the Universe database. The DICT side of a hashed file or "table" stores the field names or formulas. The dictionary items are evaluated when you execute SQL or run the old fashioned reports called Recall or English within Universe.

The VOC is the system table equivalent for a project or account. A project is a schema or account in Universe terminology.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 3:08 pm

Another way to think of it is that the "file dictionary" is a separate hashed file in which the metadata for a hashed file is stored.

Every hashed file is created with two portions; the data portion, which stores data only, and the dictionary portion, which stores metadata.

The keyword DICT can be used in queries and in BASIC to refer to the dictionary portion instead of the data portion. For example

Code: Select all

SELECT * FROM DICT DS_AUDIT;

returns the column names for the DS_AUDIT table (hashed file).

asoka_dwh · Post by **asoka_dwh** » Wed Sep 20, 2006 8:58 pm

Thanks Guys

Xpert · Post by **Xpert** » Wed Sep 20, 2006 11:52 pm

ray.wurlod wrote:Another way to think of it is that the "file dictionary" is a separate hashed file in which the metadata for a hashed file is stored.

Every hashed file is created with two portions; the data portio ...

Hi,

As you mentioned, what are those two portions? Can you explain briefly. Thanks in Advance....

ray.wurlod · Post by **ray.wurlod** » Thu Sep 21, 2006 2:11 am

My previous post does explain briefly. Invest the less than $1 per week in a premium membership.

DSXchange

DICTVOC

DICTVOC

Re: DICTVOC