Dynamically allocated sortwork datasets

Products

• Easytrieve Report Generator

Issue/Introduction

Have you ever wanted to turn off dynamically allocated sortwork datasets? By default, the Easytrieve Plus Options Table provides three dynamically allocated sortwork datasets.

Environment

Easytrieve Plus Report Generator, release 6.4

Resolution

If you need to increase this number or to turn off this option to use your own SORTWK datasets from your JCL, use the WORK parameter on the PARM statement.

PARM WORK 0 * This will turn off any dynamic allocation by Easytrieve Plus.

PARM WORK 5 * This will dynamically allocate five sortwork datasets.

OR

To change the Easytrieve Plus Options Table to eliminate the need to code the PARM, change the NUMWORK parameter.

NUMWORK=0 * This means you must always have SORTWORK DDs in your JCL.

NUMWORK=5 * This means you will always have five dynamically allocated sortwork datasets provided by Easytrieve Plus and any SORTWORK DDs specified in the JCL will not be used.

Also, when implementing a SORT activity, you can use the BEFORE parameter to identify a procedure to pre-screen input records. Adding a SELECT clause can cut down the number of records used by the Easytrieve Plus program.