File creation in Sequential File Stage

[caterin_huang]

Hi all,
is it possible for us to create a job using sequential file stage, but what we want is, the file is only created if there is any output row to the file. if there is no output rows to the file (0 row), the stage should not create the file. if it is possible, what method should I use?

and the second one is, is it possible for us to limit the number of output rows(not the sequential number of the record, but the total number of record that match the condition specified) to a stage without abort if after n rows?

thanks very much

thanks,
Caterin

[ray.wurlod]

This is not possible, as a Search would have revealed.

You can not avoid having the file created.

In an after-job subroutine you can check for zero size or one line (headings only) and delete the file, but you can not avoid having the file created.