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.
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]