Sort - Revision history

Laura: Redirected page to Sort Facility

2013-04-08T20:10:21Z

← Older revision		Revision as of 20:10, 8 April 2013
Line 1:		Line 1:
	~~Disambiguation:~~		#REDIRECT[[Sort Facility]]

	*[[~~Sort Command~~]]		<noinclude>
	*[[Sort Facility]]		[[Category:Commands]]
			</noinclude>

Laura: Replaced content with "Disambiguation: Sort Command Sort Facility"

2013-04-08T19:47:33Z

Replaced content with "Disambiguation: *Sort Command *Sort Facility"

Show changes

Laura: /* Sort Command */

2013-04-08T19:38:44Z

Sort Command

← Older revision		Revision as of 19:38, 8 April 2013
Line 6:		Line 6:

	#From READY mode. When followed by the name of the sort control file, SORT can be executed from READY mode.		#From READY mode. When followed by the name of the sort control file, SORT can be executed from READY mode.

	#From a procedure file. When followed by either a sort control file name or by the specifications that make up a single sort group, SORT can be executed from a procedure file.		#From a procedure file. When followed by either a sort control file name or by the specifications that make up a single sort group, SORT can be executed from a procedure file.

	#With the EXECUTE statement. When the name of the sort control file is included, SORT may be specified by the EXECUTE statement.		#With the EXECUTE statement. When the name of the sort control file is included, SORT may be specified by the EXECUTE statement.

Laura: /* Improving Sort Speed */

2013-04-08T18:37:59Z

Improving Sort Speed

← Older revision		Revision as of 18:37, 8 April 2013
Line 440:		Line 440:

	<noinclude>		<noinclude>
	[[Category:~~BR Manual]]~~		[[Category:Sorting and Indexing]]
	~~[[Category:BR Manual Chapter 16~~]]
	[[Category:Commands]]		[[Category:Commands]]
	[[Category:Facility Commands]]		[[Category:Facility Commands]]
	[[Category:Needs Help]]		[[Category:Needs Help]]
	</noinclude>		</noinclude>

Mikhail.zheleznov: edit

2011-12-22T15:04:59Z

edit

← Older revision		Revision as of 15:04, 22 December 2011
Line 347:		Line 347:

	MASK is a required specification that identifies up to ten sort fields and the manner (ascending or descending) in which they should be sorted.		MASK is a required specification that identifies up to ten sort fields and the manner (ascending or descending) in which they should be sorted.

			====Syntax====

			[[File:SortMask.png]]

	====Comments and Examples====		====Comments and Examples====
Line 354:		Line 358:

	====Parameters====		====Parameters====
	"Start~~-pos~~" 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 the File I/O 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.

Mikhail.zheleznov: edit

2011-12-22T14:48:12Z

edit

← Older revision		Revision as of 14:48, 22 December 2011
Line 303:		Line 303:
	====Syntax====		====Syntax====

	[[Image:~~Help0146~~.~~jpg~~]]		[[Image:SortRecord.png]]

	====Defaults====		====Defaults====

Mikhail.zheleznov: edit

2011-12-22T11:03:18Z

edit

← Older revision		Revision as of 11:03, 22 December 2011
Line 249:		Line 249:
	====Syntax====		====Syntax====

	[[Image:~~Help0145~~.~~jpg~~]]		[[Image:SortAlts.png]]

	====Parameters====		====Parameters====

Mikhail.zheleznov: edit

2011-12-22T10:53:38Z

edit

← Older revision		Revision as of 10:53, 22 December 2011
Line 11:		Line 11:
	#With the EXECUTE statement. When the name of the sort control file is included, SORT may be specified by the EXECUTE statement.		#With the EXECUTE statement. When the name of the sort control file is included, SORT may be specified by the EXECUTE statement.

	BR ~~'''~~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.		BR 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.

	==Comments and Examples==		==Comments and Examples==
Line 28:		Line 28:
	==Parameters==		==Parameters==

	The "control file~~-ref~~" parameter specifies the name (and path, if required) of the sort control file to be executed. The sort control file contains up to six different types of specifications:		The "control file" parameter specifies the name (and path, if required) of the sort control file to be executed. The sort control file contains up to six different types of specifications:
	# COMMENT (use ! as the first character of a comment)		# COMMENT (use ! as the first character of a comment)
	# FILE		# FILE
Line 48:		Line 48:
	==Types of Sort Specifications==		==Types of Sort Specifications==

	Six different types of sort specifications are allowed in each sort group. ~~Two (~~FILE and MASK) are required. The following table summarizes some information about the sort specifications:		Six different types of sort specifications are allowed in each sort group. FILE and MASK are required. The following table summarizes some information about the sort specifications:

	[[Image:SortSpecs.png]]		[[Image:SortSpecs.png]]
Line 68:		Line 68:

	====Parameters====		====Parameters====
	~~Rather than using a keyword (such as COMMENT)~~, ~~the comment specification is indicated with~~ an ~~exclamation point (!)~~.		After the required '''!''' symbol, you mat include an optional message.

	'''Message''' is the information to be displayed on the screen exactly as it is entered.		'''Message''' is the information to be displayed on the screen exactly as it is entered.

Mikhail.zheleznov: edit

2011-12-22T10:47:30Z

edit

← Older revision		Revision as of 10:47, 22 December 2011
Line 1:		Line 1:
	==Sort Command==		==Sort Command==

	The SORT command is the instruction that tells BR to begin the sorting procedure. Its only parameter is an optional '''control file~~-ref~~''' that contains all the specifications about how a particular file, or set of files, is to be sorted.		The SORT command is the instruction that tells BR to begin the sorting procedure. Its only parameter is an optional '''control file''' name that contains all the specifications about how a particular file, or set of files, is to be sorted.

	BR will execute the SORT command in any of the following 3 ways:		BR will execute the SORT command in any of the following 3 ways:

	1) From READY mode:		#From READY mode. When followed by the name of the sort control file, SORT can be executed from READY mode.

	When followed by ~~the~~ name of the sort ~~control file~~, SORT can be executed from ~~READY mode~~.		#From a procedure file. When followed by either a sort control file name or by the specifications that make up a single sort group, SORT can be executed from a procedure file.

	~~2) From a procedure~~ file:		#With the EXECUTE statement. When the name of the sort control file is included, SORT may be specified by the EXECUTE statement.

	~~When followed by either a sort control file name or by the specifications that make up a single sort group, SORT can be executed from a procedure file.~~		BR '''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.

	~~3) With the EXECUTE statement:~~

	~~When the name of the sort control file is included, SORT may be specified by the EXECUTE statement.~~

	~~The~~ '''~~Sort~~''' ~~command performs~~ a ~~[[Clear]] operation (unless~~ a ~~program is active) and begins execution of the SORT control~~ file~~. The number~~ of ~~RECORD specifications that may be used in sort control files is 20.~~

	~~A user-defined collating sequence may now be accessed through~~ the ~~FILE specification's collating sequence parameter. See "COLLATE ALTERNATE"~~ in ~~the [[BRConfig.sys]] chapter for more information~~.

	==Comments and Examples==		==Comments and Examples==
Line 50:		Line 42:
	==Technical Considerations==		==Technical Considerations==

	BR '''~~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~~.		The '''Sort''' command performs a [[Clear]] operation (unless a program is active) and begins execution of the SORT control file. The number of RECORD specifications that may be used in sort control files is 20.

			A user-defined collating sequence may now be accessed through the FILE specification's collating sequence parameter. See "COLLATE ALTERNATE" in the [[BRConfig.sys]] chapter for more information.

	==Types of Sort Specifications==		==Types of Sort Specifications==

Mikhail.zheleznov: edit

2011-12-22T10:42:22Z

edit

← Older revision		Revision as of 10:42, 22 December 2011
Line 166:		Line 166:
	{\|		{\|
	\|-valign="top"		\|-valign="top"
	\|width="90"\|'''Input file name'''\|\|is the name of the internal file containing the records to be sorted. "Path" is the sequence of directories, which leads to this file. "Drive" is the drive on which the subdirectory path and file can be found.		\|width="150"\|'''Input file name'''\|\|is the name of the internal file containing the records to be sorted. "Path" is the sequence of directories, which leads to this file. "Drive" is the drive on which the subdirectory path and file can be found.
	\|-valign="top"		\|-valign="top"
	\|width="90"\|'''Output file name'''\|\|is the name of the file that is to contain the sorted records (or just the record numbers of the records in sorted order). "Path" is the sequence of directories, which leads to this file, and "drive" is the drive on which the subdirectory path and file can be found.		\|width="150"\|'''Output file name'''\|\|is the name of the file that is to contain the sorted records (or just the record numbers of the records in sorted order). "Path" is the sequence of directories, which leads to this file, and "drive" is the drive on which the subdirectory path and file can be found.
	\|-valign="top"		\|-valign="top"
	\|width="90"\|'''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="90"\|'''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. 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.
	\|-valign="top"		\|-valign="top"
	\|}		\|}
Line 178:		Line 178:
	{\|		{\|
	\|-valign="top"		\|-valign="top"
	\|width="90"\|'''Collating sequence'''\|\|allows you to specify a collating sequence for the sort. "A" calls for the alternate collating sequence to be used, and "N" calls for the native sequence to be used. In most instances, the FILE specification collating sequence will override the BRConfig.sys file's COLLATE specification (for the sort only). There is one exception, however: if the FILES specification is N, and the BRConfig.sys specification is COLLATE ALTERNATE, the alternate collating sequence will be used. The following table should help clarify when each sequence is used. NOTE that the column labeled BRConfig.sys refers to the specification currently in use, whether it was actually specified by the BRConfig.sys file or by the CONFIG command:		\|width="150"\|'''Collating sequence'''\|\|allows you to specify a collating sequence for the sort. "A" calls for the alternate collating sequence to be used, and "N" calls for the native sequence to be used. In most instances, the FILE specification collating sequence will override the BRConfig.sys file's COLLATE specification (for the sort only). There is one exception, however: if the FILES specification is N, and the BRConfig.sys specification is COLLATE ALTERNATE, the alternate collating sequence will be used. The following table should help clarify when each sequence is used. NOTE that the column labeled BRConfig.sys refers to the specification currently in use, whether it was actually specified by the BRConfig.sys file or by the CONFIG command:
	[[Image:SortFileTable.png]]		[[Image:SortFileTable.png]]
	'''*Note''' the exception with this option		'''*Note''' the exception with this option
Line 186:		Line 186:
	{\|		{\|
	\|-valign="top"		\|-valign="top"
	\|width="90"\|'''REPLACE'''\|\| replaces an old sort output file (if it exists under the specified name) with the new output file. This eliminates the need to free or drop the file before sorting. REPLACE should only be used with caution, as the existence of the output file may indicate that a previous error has occurred. You may wish to restrict the use of this parameter to WSID temporary files and to address-out files.		\|width="150"\|'''REPLACE'''\|\| replaces an old sort output file (if it exists under the specified name) with the new output file. This eliminates the need to free or drop the file before sorting. REPLACE should only be used with caution, as the existence of the output file may indicate that a previous error has occurred. You may wish to restrict the use of this parameter to WSID temporary files and to address-out files.
	\|-valign="top"		\|-valign="top"
	\|}		\|}
Line 192:		Line 192:
	{\|		{\|
	\|-valign="top"		\|-valign="top"
	\|width="90"\|'''share spec'''\|\| allows you to specify file sharing rules for the input file. Any one of the NOSHR, SHRI, SHR or SHRU keywords is accepted. Keep in mind that the sort output file will not be in sorted order if SHR is specified and a record's sort field is modified by another workstation during the sort. (See the "share-spec" definition in the Multi-User Programming chapter and in the Definitions chapter for more information about share parameters)		\|width="150"\|'''share spec'''\|\| allows you to specify file sharing rules for the input file. Any one of the NOSHR, SHRI, SHR or SHRU keywords is accepted. Keep in mind that the sort output file will not be in sorted order if SHR is specified and a record's sort field is modified by another workstation during the sort. (See the "share-spec" definition in the Multi-User Programming chapter and in the Definitions chapter for more information about share parameters)
	\|-valign="top"		\|-valign="top"
	\|}		\|}

Sort - Revision history

Laura: Redirected page to Sort Facility

Laura: Replaced content with "Disambiguation: *Sort Command *Sort Facility"

Laura: /* Sort Command */

Laura: /* Improving Sort Speed */

Mikhail.zheleznov: edit

Mikhail.zheleznov: edit

Mikhail.zheleznov: edit

Mikhail.zheleznov: edit

Mikhail.zheleznov: edit

Mikhail.zheleznov: edit

Laura: Replaced content with "Disambiguation: Sort Command Sort Facility"