search cancel

How can sort options to optimize performance or specify functions be passed to an external sort utility (e.g. CA-SORT, DFSORT, SYNCSORT) which will be invoked during CA Easytrieve program execution?

book

Article ID: 53805

calendar_today

Updated On:

Products

PanAudit Plus Easytrieve Report Generator PAN/SQL Endevor Software Change Manager (SCM) Endevor Software Change Manager - Natural Integration (SCM) Endevor Software Change Manager - ECLIPSE Plugin (SCM) Endevor Software Change Manager - Enterprise Workbench (SCM)

Issue/Introduction

Description:

Add external sort parameters.

Solution:

Add DD statement SORTCNTL (for CA-SORT) or DFSPARM (for DFSORT and SYNCSORT) to the CA Easytrieve JCL to pass information for the extra sort parameters. This will enable the sort utility to run with these specific parameters.

For example with DFSORT:

//DFSPARM DD * 
EQUALS 
/* 
For example with CA-SORT:
//SORTCNTL DD * 
EQUALS 
/* 

Environment

Release: EDBMSU00200-6.4-Easytrieve-Report Generator-Option for DB2-MSU
Component: