Create Sequential Files only if they somme row

WoMaWil · Post by **WoMaWil** » Fri Nov 29, 2002 3:31 pm

Salut Sebastien,

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.

Bye

ray.wurlod · Post by **ray.wurlod** » Fri Nov 29, 2002 3:50 pm

You could create an after-stage or after-job call to ExecSH to test whether the file is empty and delete it.

Use "test -z pathname" to determine whether the file is empty.

sankar18 · Post by **sankar18** » Mon Dec 16, 2002 7:23 am

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.

chulett · Post by **chulett** » Mon Dec 16, 2002 10:34 am

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.

-craig