Empty Data Set

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
madhukar
Participant
Posts: 86
Joined: Fri May 20, 2005 4:05 pm

Empty Data Set

Post by madhukar »

hi all,

How to create empty data sets?
And how to clear the existing data in a dataset?

regs
Madhukar
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Madhukar,

the easiest way to create an empty dataset and also to clear the contents of one is to write a job that doesn't write any rows to the dataset.
benny.lbs
Participant
Posts: 125
Joined: Wed Feb 23, 2005 3:46 am

Re: Empty Data Set

Post by benny.lbs »

madhukar wrote:hi all,

How to create empty data sets?
And how to clear the existing data in a dataset?

regs
Madhukar
Row Generator is the esay way
tusharzade
Participant
Posts: 13
Joined: Wed Dec 15, 2004 2:19 am

Re: Empty Data Set

Post by tusharzade »

For clearing the existing data from dataset, set the Update policy as "Overwrite" and use row generator for creating the dataset with zero row.
Post Reply