How to Delete a set of Records from the Hash File

kduke · Post by **kduke** » 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.

dickfong · Post by **dickfong** » Sun Jul 06, 2003 8:22 pm

SMK

You may want to try

DELETEU FileVariable, RecordKey

if you want to delete the record in a DS routine.

Dick

WoMaWil · Post by **WoMaWil** » Tue Jul 08, 2003 8:12 am

Hi,

If you use a UV-Stage instead of a hash-Stage you are even able to delete records with a job.

Wolfgang Huerter
=====================
Cologne, Germany

ray.wurlod · Post by **ray.wurlod** » Tue Jul 29, 2003 5:27 pm

Be aware that records in hashed files are not date-stamped. Therefore, unless one of the fields within each data record contains a date-stamp of some kind, there is no mechanism for identifying the records that you might want to delete.
For example, the DataStage job logs are hashed files but, in this case, there is a field called TIMESTAMP that is used by the purge utilities.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518