Dropping columns in a hashed file
Posted: Fri Aug 11, 2006 12:50 am
Hello,
In a DS- Job I have created a hashed file, containing 26 columns. I want to use this hashed file in several DS-Jobs.
In one of these jobs I need only 4 columns of this hashed file. What I did is I loaded the definition of the hashed file, deleted the columns I did not need in this job. When I viewed the data in the hashed file I see the 4 columns I do need but the contents of the columns is besides the key columns not correct. The non-key columns are filled with the value of the first non-key columns.
My conclusion is that when you have created a hashed file and you want to use this hashed file in different jobs you need to use the complete layout of this hashed file. Dropping columns is not recommendable. Hashed files are not 'column driven'. Is that correct?
Kind regards,
Jan
In a DS- Job I have created a hashed file, containing 26 columns. I want to use this hashed file in several DS-Jobs.
In one of these jobs I need only 4 columns of this hashed file. What I did is I loaded the definition of the hashed file, deleted the columns I did not need in this job. When I viewed the data in the hashed file I see the 4 columns I do need but the contents of the columns is besides the key columns not correct. The non-key columns are filled with the value of the first non-key columns.
My conclusion is that when you have created a hashed file and you want to use this hashed file in different jobs you need to use the complete layout of this hashed file. Dropping columns is not recommendable. Hashed files are not 'column driven'. Is that correct?
Kind regards,
Jan