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
how to read Hash file column name and type through Admin?
Moderators: chulett, rschirm, roy
Re: how to read Hash file column name and type through Admin
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...
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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:
The pre-stored command LIST.DICT can be used to generate the same report.
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";
Code: Select all
LIST.DICT hashedfile
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The underlying database is based on UniVerse, which is now owned by IBM. UniVerse manuals can be downloaded for no charge from IBM website.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.