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.
Brandy Lulling, Principal Support Analyst