DSXchange

I have a situation where i count the records in a file and when the file is empty I need the count to be zero. But In DataStage it is not outputting anything.
Please advise.

Yes, that seems like a reasonable requirement.

What do you get out of DataStage when there ARE records in the file? How are you calculating this?
Think about how any calculation could be performed if no records are passing through the job.

What you need to do is to detect whether the file is empty (perhaps in a Routine activity, perhaps in an Execute Command activity). Based on that result, either write 0 to the target or run the DataStage job.

To get the count, I am creating a dummy key column and counting it in the aggregator.
As a workaround I am having a row generator generate a zero value, and add it to the count from the aggregator(above).
So, even if nothing is in the file the value will be zero.

ray.wurlod wrote:Yes, that seems like a reasonable requirement.

What do you get out of DataStage when there ARE records in the file? How are you calculating this?
Think about how any calculation could be performed ...

I am not a premium member, so I don't know if you already provided the solution or not...sometimes I wish I was a premium member. :-(

datastagenewbie wrote:sometimes I wish I was a premium member.

That, at least, is easily remedied.

datastagenewbie wrote: I have a situation where i count the records in a file and when the file is empty I need the count to be zero. But In DataStage it is not outputting anything.
Please advise.

Are you doing your counting in an Aggregator stage or outside of DataStage? Can you use an operating system command (you should have MKS installed) like 'wc -l' ?

I am also facing the same issue. Can anybody tell me the answer if it is resolved?

Regards
Prasad