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
File creation in Sequential File Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Tue Jan 26, 2010 4:05 am
- Location: Indonesia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.