What is the DICT verification order?

I do 
LIST filename NAME   .... and got back results -- it was pulling Attribute 4 of the file.  Which, was just odd.  

Turns out filename does not have a DICT called NAME
VOC does not have a DICT called NAME

SO ... where did the system FIND this dict to display attribute 4?

Once I installed a DICT called NAME In either DICT filename. or  VOC, it worked as expected.

But still -- where was it looking to 'find' something called "NAME" that was returning attribute 4??

THANKS!

I do 
LIST filename NAME   .... and got back results -- it was pulling Attribute 4 of the file.  Which, was just odd.  

Turns out filename does not have a DICT called NAME
VOC does not have a DICT called NAME

SO ... where did the system FIND this dict to display attribute 4?

Once I installed a DICT called NAME In either DICT filename. or  VOC, it worked as expected.

But still -- where was it looking to 'find' something called "NAME" that was returning attribute 4??

THANKS!

Check DICT.DICT.

UniVerse does have an entry that points to field 4.

>CT DICT.DICT NAME

     NAME
0001 D
0002 4
0003
0004 DISPLAY NAME
0005 15T
0006 S
0007
0008 VARCHAR

Hi David,

If this is on UniData the answer is the same.

DICT.DICT is the dictionary that defines the attributes in all other UniData dictionaries, including those for the VOC (vocabulary) file. (DICT.DICT is the final default for locating dictionary names related to the data file named in a query. If UniData does not find an attribute name in the file dictionary, it searches the VOC file. If it does not find the item there, it searches DICT.DICT. The DICT.DICT file resides in udthome/sys on UniData for UNIX, or udthome\\sys on UniData for Windows platforms.)

The DICT.DICT on UniData contains the following by default

LIST DICT.DICT BY TYP BY @ID TYP LOC CONV NAME FORMAT SM ASSOC 11:00:24 Apr 17 2023 1
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM ASSOC.....

@ID             D               0                      15L    S
ASSOC           D               7                      10T    S
CONV            D               3                      4L     S
FORMAT          D               5                      6L     S
LOC             D               2                      13R    S
NAME            D               4                      15L    S
SM              D               6                      2L     S
TYPE            D               1                      3L     S
MNAME           I            NAME                      15L    S
@UQ             PH  BY TYP BY @ID
                     TYP LOC CONV
                     NAME FORMAT
                    SM ASSOC
TYP             V   TRIM(TYPE[1,2                      3L     S
                    ])

Thanks,

------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

Hi David,

If this is on UniData the answer is the same.

DICT.DICT is the dictionary that defines the attributes in all other UniData dictionaries, including those for the VOC (vocabulary) file. (DICT.DICT is the final default for locating dictionary names related to the data file named in a query. If UniData does not find an attribute name in the file dictionary, it searches the VOC file. If it does not find the item there, it searches DICT.DICT. The DICT.DICT file resides in udthome/sys on UniData for UNIX, or udthome\\sys on UniData for Windows platforms.)

The DICT.DICT on UniData contains the following by default

LIST DICT.DICT BY TYP BY @ID TYP LOC CONV NAME FORMAT SM ASSOC 11:00:24 Apr 17 2023 1
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM ASSOC.....

@ID             D               0                      15L    S
ASSOC           D               7                      10T    S
CONV            D               3                      4L     S
FORMAT          D               5                      6L     S
LOC             D               2                      13R    S
NAME            D               4                      15L    S
SM              D               6                      2L     S
TYPE            D               1                      3L     S
MNAME           I            NAME                      15L    S
@UQ             PH  BY TYP BY @ID
                     TYP LOC CONV
                     NAME FORMAT
                    SM ASSOC
TYP             V   TRIM(TYPE[1,2                      3L     S
                    ])

Thanks,

------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------