viewing metadata of a hashed file

varshanswamy · Post by **varshanswamy** » Thu Mar 11, 2004 11:05 pm

I would like to know how to view the meta data in a hashed file. thankz in advance.

kcbland · Post by **kcbland** » Thu Mar 11, 2004 11:59 pm

I assume you mean a DS hash file, and not a Universe/Unidata hash file. There are two ways:

1. Go look at the job that creates and populates the hash file. As a courtesy, save the definition into the DS Manager library.

2. Import hash file metadata using DS Manager to get it into the library if you can't save it from the originating job.

Keep in mind, hash files have NO ENFORCED STRUCTURE other than non-null primary key. So, two jobs can write to the same hash file using different metadata structures and THIS IS OKAY. You must know the metadata for the rows that interest you.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 12, 2004 12:15 am

There will be a problem if you want to import the metadata from a hashed file that has been created in a directory, rather than in an account.

The problem is that the import process needs a reference in the project to the hashed file. This can be created by the SETFILE command. Search the forum for this one.