sequential file properties

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
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

sequential file properties

Post by kennyapril »

I used sequential file to capture the rejects using CSV format.

Is there any option in the properties of sequential file to not to create any file when there are no rejects.

As of now whether there are rejects or not files are being created.




Thanks
Regards,
Kenny
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No, an output file is always created.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kommven
Charter Member
Charter Member
Posts: 125
Joined: Mon Jul 12, 2004 12:37 pm

Post by kommven »

I got a similar situation and I used to count number of lines in file created to proceed, instead of checking for file presence.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

One option might be an after-job check that deletes the file if it is found to be empty.
-craig

"You can never have too many knives" -- Logan Nine Fingers
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: sequential file properties

Post by SURA »

Hence it is the 0 byte file, it won't affect in any of the way.

Still of you dont want you need to handle it in your own logic.

DSUser
Post Reply