delete records in a dataset based on a key

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kool_cons
Participant
Posts: 68
Joined: Thu Jul 07, 2005 3:41 pm

delete records in a dataset based on a key

Post by kool_cons »

Is there a way to delete specific records from a dataset? I didnot want to delete whole dataset using orchadmin utility. any help is appreciated.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't believe so, AFAIK you'd need to create a job to copy the dataset and drop the records you no longer needed during the process.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

As Craig has already stated, one cannot treat a dataset like a table and selectively delete or modify records. If you need to do that, you would need to write a job to selectively perform these actions while copying to a new dataset.
Post Reply