Sort parameter

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

I am doing a SORT in my program and I notice that in the parameters of sort there are two parameters that Easytrieve populates. They are FILSZ and DYNALLOC. Can you tell me which of the options in Easytrieve is causing these override? 

Environment

Release:
Component: EZTPLS

Resolution

You could find details description in the Language Reference Guide: 
There are two places where could override FILSZ and DYNALLOC: 

1) SORT Statement 

This statement has the following format: 

SORT input-file-name TO sorted-file-name + USING (sort-key-field-name [D] ...) 

+ [ [ACTIVITY ] [TERMINAL ] ] [COMMIT ([ ] [ ])] 

+ [ [NOACTIVITY] [NOTERMINAL] ] [SIZE record-count] 

+ [WORK number-of-work-data-sets] 

+ [BEFORE proc-name] 

+ [NAME sort-name] 

[SIZE record-count] 

Because CA Easytrieve Report Generator knows the number of records in files created by previous activities,

it automatically supplies that information to the sort program. 

If the file was not created by a previous activity, 

you can enhance sort efficiency by supplying the approximate number of records as record-count on the optional SIZE parameter. 

Record-count must be an unsigned integer. 


2) PARM - Override selected general standards for a program that are set in the Site Options Table 

PARM Statement 

PARM establishes program-level parameters in the following areas: 

SORT controls the interface to your installation's sort program. 


This statement has the following format: 

PARM + 

.... 

+ [SORT + [ {NO } ] ([ALTSEQ { } ] + [ {(YES [alt-sort-table])} ] [DEVICE device-type] + [ {storage-amount } ] 

[MEMORY { } ] + [ {(MAX [-storage-released])} ] [ {ALL [CONSOLE] } ] [ { [PRINTER] } ] [ { } ] 

[MSG ( {CRITICAL [CONSOLE] } ) ] + [ { [PRINTER] } ] [ {DEFAULT } ] [ {NO } ] 

[RELEASE core-storage-amount] + [WORK number-of-work-data-sets])] +