Delete file

rsunny · Post by **rsunny** » Mon Feb 07, 2011 10:57 am

Hi ,

Is there any command that i can use in after job subroutine to delete a file if the rows are zero.

I mean for unix there is something like

`cat filename | wc -l ` -eq 0 to delete a file using after job subroutine with DSexecute f the rows are zero

Is there anything similar to this kind in windows?

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Feb 07, 2011 11:52 am

Do you have parallel (Enterprise Edition) installed? If so you can use UNIX commands on Windows.

Otherwise you can create an after-job subroutine in DataStage BASIC that opens file using OpenSeq, uses the Status statement to determine the file size, closes the file then deletes the same if the size was zero.

rsunny · Post by **rsunny** » Mon Feb 07, 2011 12:01 pm

ray.wurlod wrote:Do you have parallel (Enterprise Edition) installed? If so you can use UNIX commands on Windows.

Otherwise you can create an after-job subroutine in DataStage BASIC that opens file using OpenSeq, ...

Hi ray,

we have only server edition and we dont have paallel edition installed.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Feb 07, 2011 12:04 pm

Then go with my other suggestion.