Posted: Thu Jul 03, 2003 9:30 am
SMK
Hash files are considered to be a temporary holding area and should not be used like a real database. Most developers which have used DataStage for several years use the delete and create option. This is safest and fastest way.
If you really want to delete records then you can write a before job routine which executes a TCL statement. Normal SQL will work like:
delete from MyHashFile where key1 = 'whatever' and key2 = 'whatever';
Kim.
Hash files are considered to be a temporary holding area and should not be used like a real database. Most developers which have used DataStage for several years use the delete and create option. This is safest and fastest way.
If you really want to delete records then you can write a before job routine which executes a TCL statement. Normal SQL will work like:
delete from MyHashFile where key1 = 'whatever' and key2 = 'whatever';
Kim.