Version 8.2.3 for Mainframes	SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT

This Natural profile parameter is used to control the sort program used for the processing of SORT statements. It corresponds to the NTSORT macro in the Natural parameter module NATPARM.

Notes:

1. The keyword subparameters of SORT or NTSORT can be used to specify options that control the handling of the sort program to be used when a SORT statement is executed.
2. The sort program to be used can be either Natural's internal one (the default for all environments) or an external one. The type of sort program used depends on the setting of the keyword subparameter EXT.

The following topics are covered below:

• SORT Parameter Syntax

• NTSORT Macro Syntax

• Keyword Subparameters

SORT Parameter Syntax

The SORT parameter is specified as follows:

For names and values of the keyword subparameters, see Keyword Subparameters.

NTSORT Macro Syntax

The NTSORT macro is specified as follows:

         NTSORT EXT=value,                                             *
               EXTEOJ=value,                                           *
               EXTNAME=value,                                          *
               EXTOPT=value,value,...,                                 *
               STORAGE=value,                                          *
               WRKSIZE=value

For names and values of the keyword subparameters, see Keyword Subparameters.

Keyword Subparameters

EXT | EXTEOJ | EXTNAME | EXTOPT | STORAGE | WRKSIZE

EXT - Use of External Sort Program

EXT=value specifies if an external sort program is to be used or not.

EXTEOJ - Action in the Event of an Error

EXTEOJ=value specifies the action to be taken if an error is detected during the execution of the external sort program.

EXTNAME - Name of External Sort Program

EXTNAME=value specifies the name of the external sort program to be used.

Note:
This subparameter does not apply under BS2000/OSD.

EXTOPT - Additional Options for External Sort Program

EXTOPT=(value,value,...) specifies additional options for the external sort program.

Note:
This subparameter does not apply under BS2000/OSD.

Natural generates the necessary field and format parameters and passes them to the external sort program. With EXTOPT, you can specify additional parameters to be passed to the external sort program. You can only specify parameters that are part of the control statement syntax of your external sort program.

You can specify up to two option strings which are delimited by a slash (/). The first option string is appended to the SORT control statement, the second option string is used to build an OPTION control statement. You may omit the option string before or after the slash. If the option string after the slash is omitted no OPTION control statement is generated at all.

The whole option string must be enclosed in single quotes ('...'). For compatibility reasons, it is still possible to have the option string enclosed in brackets instead.

For compatibility reasons, a single option string without a leading or trailing slash is handled differently. Depending on the underlying operating system, the options are appended to the following control statements:

Example:

The additional parameters can be specified as in the following example:

EXTOPT=(SIZE=E2000000,NOEQUALS,DYNALLOC=(3350,8))
EXTOPT='SIZE=E2000000,NOEQUALS,DYNALLOC=(3350,8)'
EXTOPT='SIZE=E2000000,NOEQUALS,DYNALLOC=(3350,8)/NOCHECK'
EXTOPT='/NOCHECK'
EXTOPT='WORK=4/'

STORAGE - Type of Storage Medium

STORAGE=value specifies the type of storage medium to be used by Natural's internal sort program.

Note:
In general, the SORT statement first tries to use the remaining storage in WRKSIZE. If the number of records does exceed this storage, the SORT statement tries to use intermediate storage to additionally process records.

Notes Concerning SD Files under Com-plete/SMARTS

• The files are allocated as temporary SD files. They are allocated for a stack level. This means, the name syntax of the SORT SD files is:

  &&STsnnn

  Where:

  &&	Indicator for a temporary SD file
  ST	Standard prefix for the SD sort file
  s	Stack level
  nnn	Sequence number within a single SORT run

• SMARTS work files are located in the SMARTS Portable File System. The path must be specified with the SMARTS environment variable $NAT_WORK_ROOT. A special directory named SORT for SORT work files is added and for each user, a different directory is created named by the user ID. The resulting directory is then $NAT_WORK_ROOT/sort/userid. The naming of the SORT work files corresponds to the SD files under Com-plete.

Note Concerning Usage of Sort Buffer Pool

If you want to use a sort buffer pool, define the SORT keyword subparameter STORAGE=BP to indicate that a sort buffer pool is to be used for any additional storage beyond the defined WRKSIZE. Simultaneously, use the profile parameter BPI or the parameter macro NTBPI to make a buffer pool of TYPE=SORT and NAME=name known to Natural, for example: BPI=(TYPE=SORT,NAME=XYZ). When a name ist specified with the BPI keyword subparameter NAME, reference is made to a global sort buffer pool, whereas a local sort buffer pool can be specified by NAME=' ' (blank).

WRKSIZE - Size of Work Buffer Used by Sort Program

WRKSIZE=value specifies the size of the work buffer used by the sort program.

Note:
The work buffer specified by WRKSIZE accommodates internal sort control data. The remaining storage is used to collect and sort the records. The size of the sort control data depends on various factors (the WRKSIZE itself, the sort record length, the number of sort keys, their size and format) and can therefore not be calculated in a formal way.

www.softwareag.com

Copyright © 1979-2013 Software AG, Darmstadt, Germany.

SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT