Page 1 of 1

delete records in a dataset based on a key

Posted: Mon Sep 21, 2009 7:25 am
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.

Posted: Mon Sep 21, 2009 7:36 am
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.

Posted: Mon Sep 21, 2009 8:25 am
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.