Sort Facility - Revision history

GomezL: Sort expanding on A vs B for "Address Out"

2023-06-09T19:58:33Z

Sort expanding on A vs B for "Address Out"

← Older revision		Revision as of 19:58, 9 June 2023
Line 183:		Line 183:
	\|width="150"\|'''Workpath'''\|\|is a sequence of subdirectories, which leads to the disk area where BR should create a temporary Workspace. "Workrive" is the drive on which this subdirectory path can be found. There is no need to specify a name for the work file, as BR handles this internally. See the Technical Considerations section below for formulas to help you estimate work file space.		\|width="150"\|'''Workpath'''\|\|is a sequence of subdirectories, which leads to the disk area where BR should create a temporary Workspace. "Workrive" is the drive on which this subdirectory path can be found. There is no need to specify a name for the work file, as BR handles this internally. See the Technical Considerations section below for formulas to help you estimate work file space.
	\|-valign="top"		\|-valign="top"
	\|width="150"\|'''FILE spec'''\|\|allows you to choose from three different sort storage methods. "A" calls for an address-out sort, which is to be stored in PD3 format. "B" calls for an address-out sort, which is to be stored in B4 format. In both cases, the "address" which is being stored is the relative record number. "R" calls for a record-out sort, which means that each entire record is written to the output file. See the Technical Considerations section below for formulas to help you estimate address-out and record-out space. Address-out sorts execute much more quickly than record-out sorts, and the B storage method is faster than the A storage method.		\|width="150"\|'''FILE spec'''\|\|allows you to choose from three different sort storage methods. "A" calls for an address-out sort, which is to be stored in PD3 format. "B" calls for an address-out sort, which is to be stored in B4 format. (''Note: Not BH4'') In both cases, the "address" which is being stored is the relative record number. "R" calls for a record-out sort, which means that each entire record is written to the output file. See the Technical Considerations section below for formulas to help you estimate address-out and record-out space. Address-out sorts execute much more quickly than record-out sorts, and the B storage method is faster than the A storage method. When using the A Method, PD 3 has a limit of 99,999, so any records >10,000 will have a 0 in the PD 3 value. When possible using "B" to avoid problems with large data sets.
	\|-valign="top"		\|-valign="top"
	\|}		\|}

Gordon.dye: /* Parameters */

2022-08-19T13:33:16Z

Parameters

← Older revision		Revision as of 13:33, 19 August 2022
Line 328:		Line 328:
	====Parameters====		====Parameters====

	RECORD's first parameter must either be "I" (include) or "O" (omit). If you choose I, BR will include all records with select fields that fall inside the values you specify. If you choose O, BR will ~~include~~ all records with select fields that fall ~~inside~~ the values you specify		RECORD's first parameter must either be "I" (include) or "O" (omit). If you choose I, BR will include all records with select fields that fall inside the values you specify. If you choose O, BR will exclude all records with select fields that fall outside the values you specify.

	"Start pos" is the starting position of the select field, and "field length" is its character length. "Form spec" indicates the format of the field (C, N, PD, etc.; see the discussion of [[Category:File_Operations#Format_Specifications\|format specifications]] in the [[File Operations]] Section for more information).		"Start pos" is the starting position of the select field, and "field length" is its character length. "Form spec" indicates the format of the field (C, N, PD, etc.; see the discussion of [[Category:File_Operations#Format_Specifications\|format specifications]] in the [[File Operations]] Section for more information).

Laura: /* Syntax */

2014-05-08T17:06:45Z

Syntax

← Older revision		Revision as of 17:06, 8 May 2014
Line 37:		Line 37:

	===Syntax===		===Syntax===
	SORT [<control file>]		SORT [<[[Sort control file\|control file]]>]
	[[Image:Sort.png]]		[[Image:Sort.png]]

Laura: /* Syntax */

2014-05-06T18:04:20Z

Syntax

← Older revision		Revision as of 18:04, 6 May 2014
Line 37:		Line 37:

	===Syntax===		===Syntax===
			SORT [<control file>]
	[[Image:Sort.png]]		[[Image:Sort.png]]

Laura: /* Defaults */

2014-02-16T02:26:51Z

Defaults

← Older revision		Revision as of 02:26, 16 February 2014
Line 168:		Line 168:
	#Use the current directory.		#Use the current directory.
	#Use the current drive.		#Use the current drive.
	#Record-out sort.		#Record-out sort (FILE spec)
	#Default according to the COLLATE specification in the BRConfig.sys file.		#Default according to the COLLATE specification in the BRConfig.sys file.
	#Do not replace existing file by same name.		#Do not replace existing file by same name.

Laura at 19:17, 7 August 2013

2013-08-07T19:17:09Z

← Older revision		Revision as of 19:17, 7 August 2013
Line 1:		Line 1:
	Business Rules sort facility allows you to produce a sorted output file from a randomly ordered file of records, and to rearrange the records in a variety of ways.		Business Rules sort facility allows you to produce a sorted output file from a randomly ordered file of records, and to rearrange the records in a variety of ways.

			A simple [[Index and Sort facilities Tutorial#Basic Overview of SORT\|Sort Tutorial]] is now available.

	==Sort Command==		==Sort Command==

Laura: /* Parameters */

2013-07-22T17:34:40Z

Parameters

← Older revision		Revision as of 17:34, 22 July 2013
Line 375:		Line 375:
	"Start position" is the starting record position of the field to be sorted, and "field length" is its character length.		"Start position" is the starting record position of the field to be sorted, and "field length" is its character length.

	"Form spec" indicates the format, or data type, of the field. The format specifications which can be used in the MASK specification include the following: B (Binary); BL (Binary low); BH (Binary high); C (Character); D (Double-precision); L (Long); N (Numeric); PD (Packed decimal); S (Single-precision) and ZD (Zoned decimal). See [[File Operations]] ~~chapter~~ for more information about each of these format types.		"Form spec" indicates the format, or data type, of the field. The format specifications which can be used in the MASK specification include the following: B (Binary); BL (Binary low); BH (Binary high); C (Character); D (Double-precision); L (Long); N (Numeric); PD (Packed decimal); S (Single-precision) and ZD (Zoned decimal). See [[:Category:File_Operations#Format_Specifications\|Format Specifications]] in the [[File Operations]] section for more information about each of these format types.

	The last parameter must either be "A" to sort the specified record in ascending order, or "D" to sort it in descending order.		The last parameter must either be "A" to sort the specified record in ascending order, or "D" to sort it in descending order.

Laura: /* Parameters */

2013-07-22T17:32:32Z

Parameters

← Older revision		Revision as of 17:32, 22 July 2013
Line 327:		Line 327:
	RECORD's first parameter must either be "I" (include) or "O" (omit). If you choose I, BR will include all records with select fields that fall inside the values you specify. If you choose O, BR will include all records with select fields that fall inside the values you specify		RECORD's first parameter must either be "I" (include) or "O" (omit). If you choose I, BR will include all records with select fields that fall inside the values you specify. If you choose O, BR will include all records with select fields that fall inside the values you specify

	"Start pos" is the starting position of the select field, and "field length" is its character length. "Form spec" indicates the format of the field (C, N, PD, etc.; see the discussion of format specifications in the File ~~I/O chapter~~ for more information).		"Start pos" is the starting position of the select field, and "field length" is its character length. "Form spec" indicates the format of the field (C, N, PD, etc.; see the discussion of [[Category:File_Operations#Format_Specifications\|format specifications]] in the [[File Operations]] Section for more information).

	BR compares the data in the specified field to lower and upper limits before determining whether or not its record should be included in the sort.		BR compares the data in the specified field to lower and upper limits before determining whether or not its record should be included in the sort.

Laura: /* Parameters */

2013-07-22T17:27:35Z

Parameters

← Older revision		Revision as of 17:27, 22 July 2013
Line 373:		Line 373:
	====Parameters====		====Parameters====

	"Start position" is the starting record position of the field to be sorted, and "field length" is its character length. "Form spec" indicates the format, or data type, of the field. The format specifications which can be used in the MASK specification include the following: B (Binary); BL (Binary low); BH (Binary high); C (Character); D (Double-precision); L (Long); N (Numeric); PD (Packed decimal); S (Single-precision) and ZD (Zoned decimal). See ~~the~~ File ~~I/O~~ chapter for more information about each of these format types.		"Start position" is the starting record position of the field to be sorted, and "field length" is its character length.

			"Form spec" indicates the format, or data type, of the field. The format specifications which can be used in the MASK specification include the following: B (Binary); BL (Binary low); BH (Binary high); C (Character); D (Double-precision); L (Long); N (Numeric); PD (Packed decimal); S (Single-precision) and ZD (Zoned decimal). See [[File Operations]] chapter for more information about each of these format types.

	The last parameter must either be "A" to sort the specified record in ascending order, or "D" to sort it in descending order.		The last parameter must either be "A" to sort the specified record in ascending order, or "D" to sort it in descending order.

Laura at 18:47, 11 July 2013

2013-07-11T18:47:31Z

@@ Line 392: / Line 392: @@
 A sort group contains all the necessary specifications for controlling the sorting of a single file. If only one file is to be sorted, a single sort group may simply follow a SORT command when it is specified in a procedure file. When several files are to be sorted, the sort group for each file may be placed together in a single sort control file.
-===Sort Control File===
+==Sort Control File==
+{{:Sort control file}}
 ==Sort Baseyear Processing==