DICTVOC
Moderators: chulett, rschirm, roy
DICTVOC
Can anybody explain what is DICTVOC.
Re: DICTVOC
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.
With regards,
Xpert
Xpert
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.
The VOC is the system table equivalent for a project or account. A project is a schema or account in Universe terminology.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 returns the column names for the DS_AUDIT table (hashed file).
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;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,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 ...
As you mentioned, what are those two portions? Can you explain briefly. Thanks in Advance....
With regards,
Xpert
Xpert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: