Email from a SEQUEL Script

Another approach to create Excel data is simply to use the SEQUEL EXECUTE command within a script that runs a predefined view. The EXECUTE command can specify an output format of Excel (among many other PC formats) along with an e-mail recipient. In the script below a runtime prompt is used to supply e-mail address for the recipient.

Script Commands

 

10

MONMSG

 

20

EXECUTE

VIEW(SEQUELEX/CUSTLIST)
PCFMT(*XLS)
RECIPIENT('&&EMAIL')

 

Runtime Variable

The variable &&email is defined as:

 

Seq

Variable

Type

Prompt Text

Length

Dec

5

&EMAIL

EXPR

&EMAIL

80

0