Page 1 of 1
how to read Hash file column name and type through Admin?
Posted: Wed Sep 15, 2004 7:02 am
by 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
Re: how to read Hash file column name and type through Admin
Posted: Wed Sep 15, 2004 7:27 am
by 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...
him121 wrote: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
Posted: Wed Sep 15, 2004 4:24 pm
by 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.
Posted: Thu Sep 16, 2004 3:13 am
by 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
Posted: Thu Sep 16, 2004 4:05 pm
by 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.