empty dataset

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
tostay2003
Participant
Posts: 97
Joined: Tue Feb 21, 2006 6:45 am

empty dataset

Post by tostay2003 »

Since dataset doesn't get created when no records are written to it due to constraints in transformer (or any other stage).

What would be the best approach to create an empty dataset? As this should be called in multiple jobs with dataset name as an argument.
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

With a policy of create or overwrite, you should still get a zero rows dataset, even if no qualifying rows are output.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: empty dataset

Post by chulett »

tostay2003 wrote:Since dataset doesn't get created when no records are written to it due to constraints in transformer (or any other stage).
This is not correct.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply