Universe table column structure query

[nikhilanshuman]

Hi,
When i use following query in TCL :

SELECT * from RT_STATUS415;

I get following data :

Code: Select all

TestJob.Befor
e.1
TestJob.After
.2
TestJob.Befor
e.oeeDimFF

Also, LIST.DICT RT_STATUS shows only one column name '@ID'

Code: Select all

DICT RT_STATUS    09:43:47am  26 May 2010  Page    1

               Type &
Field......... Field. Field........ Conversion.. Column......... Output Depth &
Name.......... Number Definition... Code........ Heading........ Format Assoc..

@ID            D    0                            RT_STATUS       10L    S

1 records listed.

From search in dsxchange,i found below query :

SELECT @ID FMT '46L', F1, F2,F3,F4,F5 FROM RT_STATUS415 USING DICT VOC

The result was :

Code: Select all

VOC. TestJob.Before.1
F1.. JOB
F2.. 2
F3.. 2010-05-24
     07:20:49
F4.. 2010-05-24
     07:21:00
F5.. -8890

When i queried the table structure,i got only one column @ID.Even the select * query is returning only 1 column.

My confusion is :
By making use of VOC how the additional columns are retrieved(F1,F2,F3,F4,F5)? From where the additional column information is fetched as shown above.I read that VOC maintains pointer to hash files.
[/b]

[ArndW]

In UniVerse the table contents and the table description (DDL) are stored in separate places and are not necessarily the same. The DICTionary of a file can also be augmented by other items defined in the VOC file, as is done for such column names as F1, F2, etc.
In this case the DICT for the file only contains the key @ID definition, but the actual contents has more columns.