Posted Tue, 05 Nov 2019 23:07:00 GMT by

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.


Posted Wed, 06 Nov 2019 01:57:25 GMT by

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

You must be signed in to post in this forum.