how to read Hash file column name and type through Admin?

[him121]

hi..
guys i want to some of the adminstrator command for reading and writing the hash files.

i know some commands..
like..

e.g
suppose my hash file name is

HASH_XYZ

column name type

A (key) Char
B int
C int


now i know select and Insert command to fetch records and write data into them..
but i want to know something like if i want information about
Column name ,type,key of the HASH file how can i know that through administrator..
kind of sp_help command in datastage
thanx in advance..

himanshu

[lh3]

Hello,

To explore hash file structure you can use ReTrieve command LIST DICT, e.g.
LIST DICT HASH_XYZ

There is also HELP command, but accessible only from UV engine...

hi..
guys i want to some of the adminstrator command for reading and writing the hash files.

i know some commands..
like..

e.g
suppose my hash file name is

HASH_XYZ

column name type

A (key) Char
B int
C int


now i know select and Insert command to fetch records and write data into them..
but i want to know something like if i want information about
Column name ,type,key of the HASH file how can i know that through administrator..
kind of sp_help command in datastage
thanx in advance..

himanshu

[ray.wurlod]

The file dictionary (metadata) for a hashed file is stored in its "file dictionary". You get at this by preceding the hashed file name by the DICT keyword in a query; without the keyword you see the actual data. In UniVerse SQL:

Code: Select all

SELECT "FIELD", "FIELD.TYPE", "FIELD.DEF", "FIELD.CONV", "FIELD.HEAD", "FIELD.FMT", "FIELD.ASSOC" FROM DICT hashedfile ORDER BY "FIELD.NO", "TYPE";

The pre-stored command LIST.DICT can be used to generate the same report.

Code: Select all

LIST.DICT hashedfile

[him121]

thanx
ray
for for gr8 reply...
can u please tell me the how to learn or know all this admin command..
is there any book or online manual available

[ray.wurlod]

The underlying database is based on UniVerse, which is now owned by IBM. UniVerse manuals can be downloaded for no charge from IBM website.