I want SEQUEL to run my view every day and send the results to my PC. How can I make sure the file has a unique name each day?
You can create a SEQUEL Script to run the EXECUTE command and create Excel output that is e-mailed to your PC. For example, your script might look something like this:
EXECUTE
VIEW(SEQUELEX/CUSTLIST) PCFMT(*XLS) +
TOSTMF('/tmp/CMPO&&date.xls') +
RECIPIENT('you@work.com')
Notice the ‘&&date’ variable in the TOSTMF parameter. In the Variable Tab of the script designer, you can define the Type as EXPR, the Prompt Text as *NOPROMPT, and the Default Value as *JOBDATE to create a unique file name based on the date the job runs. These results are stored in the TMP folder on the System i and you can e-mail the file to yourself using the RECIPIENT parameter.