I don't see your problem. I you have no (=zero) row on your link2 and your link2 goes to a sequential file then it is okay that the file is empty (has zero lines). All other results would be a problem.
Wolfgang
Guten tag Wolfgang !
I just have a transformer with one constraint. This constraint is a lookup on a OCI.
If notisnull the row go to a link1 on another OCI.
If isnull the row must go a link2 and create a sequential files.
With the monitor, i have no row on my link2 but after the job i have an empty sequential file !
I's my problem.
What do you with second sequential file.If there is no record in the sequential file, you want to delete it.Are you asking how to send the not null to first sequential file andthe null to second sequential file.can you make it clear.
I think this thread is basically closed and 'scognet' got their answer. There is no way to avoid the creation of the sequential file referenced by the stage, the simple act of opening the file creates it with zero length. If this empty file really isn't wanted, it needs to be explicitly deleted after the job ends after properly testing to verify that it is empty, as described above.