Hash file aKey
Posted: Tue Jan 25, 2005 5:39 pm
I need to do the following
Create a Hashfile with the following composite keys
Field one - Integer --Duplicates Allowed [Defined as key on creation]
Field two - Date [Defined as key on creation]
Field Three - Date [Defined as key on creation]
Use Hash File as a look up for the above created hash file as follows
Field one - Integer --Duplicates Allowed [Defined as key on reading]
Field two - Date [Not Defined as key on reading]
Field Three - Date [Not Defined as key on reading]
Will I lose records in Field1 on reading by elimination of duplicate records on the hash files or will this retain the duplicates (I need to retain the duplicates)
In a nutshell on generation of the hash file I have three composite keys(making it unique) and on reading them I need to read from one of the fields which is not unique and not lose the duplicate records.
The lookup is for a large table an is required in multiple jobs
Is it a good idea to do the above or is there a better way to do it?
Create a Hashfile with the following composite keys
Field one - Integer --Duplicates Allowed [Defined as key on creation]
Field two - Date [Defined as key on creation]
Field Three - Date [Defined as key on creation]
Use Hash File as a look up for the above created hash file as follows
Field one - Integer --Duplicates Allowed [Defined as key on reading]
Field two - Date [Not Defined as key on reading]
Field Three - Date [Not Defined as key on reading]
Will I lose records in Field1 on reading by elimination of duplicate records on the hash files or will this retain the duplicates (I need to retain the duplicates)
In a nutshell on generation of the hash file I have three composite keys(making it unique) and on reading them I need to read from one of the fields which is not unique and not lose the duplicate records.
The lookup is for a large table an is required in multiple jobs
Is it a good idea to do the above or is there a better way to do it?