emptying the dataset using orchadmin

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
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

emptying the dataset using orchadmin

Post by pandeesh »

Hi,

Consider that a dataset contains 1million records and i want to delete only the records(not the entire dataset) and keep it as the empty dataset.
Is it possible to achieve via orchadmin?

Thanks
pandeeswaran
Rakesh311
Participant
Posts: 36
Joined: Wed Aug 04, 2010 10:53 pm
Location: Banglore
Contact:

Post by Rakesh311 »

yes it is
you have truncate command in orchadmin

go through 'orchadmin man'

regards
Rakesh
rAKESH
kmsekhar
Premium Member
Premium Member
Posts: 58
Joined: Fri Apr 16, 2010 12:58 pm
Location: Chn

Re: emptying the dataset using orchadmin

Post by kmsekhar »

To Truncate DataSet: $orchadmin truncate [options] file.ds
Thanks,
Sekhar
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

Thanks all
pandeeswaran
Post Reply