How do I edit the Spooled File Rule Option parameter field?
When editing a Spooled File Monitor Rule the Option parameters field can overflow. Here is a screen shot of an example:
Change spooled file rule (CHGSPLRUL)
Type choices, press Enter.
Spooled file size (Kb):
From . . . . . . . . . . . . . *ALL 0-999999999, *ALL
To . . . . . . . . . . . . . . 1-999999999, *MAX
Rule priority . . . . . . . . . 200 1-9999, *SAME
Option . . . . . . . . . . . . . 21 Character value, *SELECT...
Option parameters . . . . . . . 'FROMFILE(&F) TOSTMF(''/Home/demonstration/d
emonstration.xlsx'') JOB(&N/&U/&J) SPLNBR(&S) STMFOPT(*REPLACE) EMAIL(*YES) EMAI
LOPT(*NO ''This is a demonstration'' *NORMAL *NO *NO Demonstration.xlsx *NO *NON
E *NO *ENVVAR *ENVVAR *ENVVAR *ENVVAR *DFT 60) EMAILFROM(doNotReplay@ariadnesoft
ware.co.uk doNotReply) EMAILTO((support@ariadnesoftware.co.uk Steve *PRI)) EMAIL
MSG(''This is to demonstrate how to display all of the parameters on the OPTION
PARAMETER field'' *BOTH *MSG) EXCEL(*XLSX *FIRST *FIRST *SYSVAL *JOB ...
Text 'description' . . . . . . . *BLANK
As you can see the 'Option parameter' field is full and does not show the complete list of parameter values.
A common question is "How do I edit the Option parameter field?"
To edit all of the 'option parameters' field:
1. Position the cursor at the first character of the Option parameter field.
2. Type *PROMPT
3. clear the remainder of the Option parameter field by pressing the FIELD EXIT key or DELETE.
Change spooled file rule (CHGSPLRUL)
Type choices, press Enter.
Spooled file size (Kb):
From . . . . . . . . . . . . . *ALL 0-999999999, *ALL
To . . . . . . . . . . . . . . 1-999999999, *MAX
Rule priority . . . . . . . . . 200 1-9999, *SAME
Option . . . . . . . . . . . . . 21 Character value, *SELECT...
Option parameters . . . . . . . *PROMPT
...
Text 'description' . . . . . . . *BLANK
4. Press ENTER and the relevant command prompt will be displayed.
Convert Spooled File to Excel (CVTSPLXLS)
Type choices, press Enter.
From spooled file name . . . . . > &F Name, *SELECT, *SLT
To stream file name or *FTP . . > '/Home/demonstration/demonstration.xlsx'
Job name . . . . . . . . . . . . > &J Name, *, *SBMJOB, *SLT
User . . . . . . . . . . . . . > &U Name
Number . . . . . . . . . . . . > &N 000000-999999
Spooled file number . . . . . . > &S 1-999999, *LAST, *ONLY, *SLT
Retrieve parameter set . . . . . *SPLF
Stream file option . . . . . . . > *REPLACE *NONE, *REPLACE, *ADD...
Email the output? . . . . . . . > *YES *NO, *YES, *ONE
5. Make your amendments and press ENTER
6. The Rule will be updated and the Work with Spooled File Rules screen is displayed