Updating / writing ONLY to certain columns in a hashed file

sec105105 · Post by **sec105105** » Mon Dec 16, 2013 3:33 pm

Is it possible to update *certain* columns in a hashed file? I know writes to HFs are row-destructive (if that's the term) , but has anyone come up with an approach through transformer or whatever to update conditionally certain columns?

In my case, I have a group of X records within a key, and various columns are populated in each of the records. I want to write the non-null columns to one final Hashed file record.

Thanks!

ray.wurlod · Post by **ray.wurlod** » Mon Dec 16, 2013 9:20 pm

You can do this by using a UniVerse (UV) stage.

For that to work, there must exist a VOC pointer to the hashed file.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Dec 17, 2013 9:21 am

Once you are in the uniVerse shell in the correct project you can use the SETFILE command to create a VOC pointer.

1) cd $DSHOME
2) bin/uvsh
3) LOGTO projectname
4) SETFILE (respond to prompts)
5) QUIT

ray.wurlod · Post by **ray.wurlod** » Tue Dec 17, 2013 2:38 pm

Or just run the SETFILE command from an Administrator client Command window in the project.