Adding Dictionary entries

[elavenil]

Static hash file created using CREATE.FILE option and the metadata (Column names and key in the hash file) not created in the dictionary.

When the hash file gets loaded from a job, how would the job get affected? Hash file would show the right results after the hash file gets loaded? if yes, what is the advantage of adding dictionary entries in the dictionary.

Can someone explain this pls.

Thanks in advance.

Regards
Saravanan

[WoMaWil]

Saravanan,

you are right, a hash-file does not nessesarily need a dictionary file and you even can process loading a totaly new column structure in the next load of the hash-file.

If you want to use SQL to query your Hash-File (in a Routine, in an Universe-Stage or in a uv-Session) you need to have them.

For to use Hash-Files you should read you a bit through the manual. There are some problems, which may occure to those who don't completly understand Hash-Files.

Kind regards
Wolfgang

[ray.wurlod]

As Wolfgang stated, the BASIC progamming language can access fields in hashed file records without any metadata needing to be defined. Indeed this is how DataStage Engine can access the Repository tables without the full metadata being defined.

Metadata are only needed for queries. Most databases insulate themselves from uses by allowing access ONLY through queries, even when the "native API" is used. This is not the case for UniData and UniVerse (and therefore DataStage). Versions 7.x and earlier, anyway.

[elavenil]

Hi Wolfgang,

Thanks for your response.

I have understood where and when to use Static and Dynamic hashed files. I have read and understood 'ServJob.pdf' document. Is there any other document which i can refer to and hope that would help me to understand adding dictionary entries.

Pls let me know.

Regards
Saravanan

[ray.wurlod]

Searching here, of course, and also the UniVerse 9.6 manuals on the IBM website.

[elavenil]

Thanks Ray. I will check the IBM site to get those manuals.

Regards
Saravanan