Creating blank file when no data present

How do you create a blank file if there isn't any data available in the view?  

I've created some extracts (views) and there are some days, during the weekend, that data isn't available but I still need a blank file generated.

Thank you in advance.

John

Hi John,

Thank you for your post to the Forum.

You can use the EXECUTE command in the SEQUEL library to create a file whether the view contains data or not. Here is an example:      SEQUEL/EXECUTE SQL('select * from sequelex/custmast where cstte="xx"') PCFMT(*XLSX) TOSTMF('/brandy/blank.xlsx')

Please note that the file will be created in the directory specified, however it will not be emailed. If you have any further questions please don't hesitate to reach out to support at [email protected] or by calling 952.933.0609.

Kind Regards,

Brandy Lulling, Principal Support Analyst