Chapter 15 - Revision history

Gordon.dye: /* 15.3 The REC= clause */

2026-06-29T04:27:05Z

15.3 The REC= clause

← Older revision		Revision as of 04:27, 29 June 2026
Line 142:		Line 142:
	The REC= clause, which can be used in the syntax of all I/O statements except REREAD, tells the Business Rules! system which record should be accessed when the file is opened for relative processing. Since the REREAD statement only processes the last record successfully read, regardless of how it was read, there is no need to use a REC= clause with this statement.		The REC= clause, which can be used in the syntax of all I/O statements except REREAD, tells the Business Rules! system which record should be accessed when the file is opened for relative processing. Since the REREAD statement only processes the last record successfully read, regardless of how it was read, there is no need to use a REC= clause with this statement.

	The REC= clause ~~must be the last clause before the colon in an I/O statement. It~~ must begin with REC= followed by any numeric expression. Remember that numeric expressions can be numeric constants or numeric variables (with or without subscripts), and that expressions can also include arithmetic as well as function calls. Some examples of REC= clauses with these different types of expressions are:		The REC= clause must begin with REC= followed by any numeric expression. Remember that numeric expressions can be numeric constants or numeric variables (with or without subscripts), and that expressions can also include arithmetic as well as function calls. Some examples of REC= clauses with these different types of expressions are:

	500 READ #1, USING 60, REC=12:A$ (Numeric Expression)		500 READ #1, USING 60, REC=12:A$ (Numeric Expression)

Laura: /* Quick Quiz 15.7 */

2013-08-16T17:21:22Z

Quick Quiz 15.7

← Older revision		Revision as of 17:21, 16 August 2013
Line 545:		Line 545:


	NEXT:[[Chapter 16]]		NEXT:[[Chapter 16\|Keyed File Processing]]

	[[BR Tutorial\|Back to Index]]		[[BR Tutorial\|Back to Index]]

Laura at 01:18, 16 July 2013

2013-07-16T01:18:26Z

← Older revision		Revision as of 01:18, 16 July 2013
Line 550:		Line 550:

	<noinclude>		<noinclude>
	[[Category:Tutorial]]		[[Category:Tutorial 1]]
	</noinclude>		</noinclude>

Laura: /* Quick Quiz 15.7 */

2013-07-15T21:05:35Z

Quick Quiz 15.7

← Older revision		Revision as of 21:05, 15 July 2013
Line 548:		Line 548:

	[[BR Tutorial\|Back to Index]]		[[BR Tutorial\|Back to Index]]

			<noinclude>
			[[Category:Tutorial]]
			</noinclude>

Laura: /* Quick Quiz 15.7 */

2013-07-03T22:48:41Z

Quick Quiz 15.7

← Older revision		Revision as of 22:48, 3 July 2013
Line 542:		Line 542:
	b) An address out sort will execute faster than a record out sort when sorting the same records in the same way (if the record length of the input file is bigger than 3).		b) An address out sort will execute faster than a record out sort when sorting the same records in the same way (if the record length of the input file is bigger than 3).

	~~Answer: <br>~~		[[Answers 15.7]] <br>
	1.~~) T~~ <br>
	~~2.) T <br>~~

	NEXT:[[Chapter 16]]		NEXT:[[Chapter 16]]

	[[BR Tutorial\|Back to Index]]		[[BR Tutorial\|Back to Index]]

Laura: /* End-Chapter Exercise */

2013-07-03T22:48:23Z

End-Chapter Exercise

← Older revision		Revision as of 22:48, 3 July 2013
Line 531:		Line 531:

	====End-Chapter Exercise====		====End-Chapter Exercise====
	To practice this, let’s sort the CHEKBOOK.INT file to arrange all the checks by account number from 1 to 99. Also, within each account, let’s arrange the checks from largest amount to smallest amount. No deposits should be included, and no withdrawals that are not checks. In other words, let’s exclude everything without a check number. Either using a PRESORT program or on your own, do this now.		To practice this, let’s sort the CHEKBOOK.INT file to arrange all the checks by account number from 1 to 99. Also, within each account, let’s arrange the checks from largest amount to smallest amount. No deposits should be included, and no withdrawals that are not checks. In other words, let’s exclude everything without a check number. Either using a PRESORT program or on your own, do this now.

			[[Solutions#CHAPTER 15\|Solution]]

	===Quick Quiz 15.7===		===Quick Quiz 15.7===

Laura: /* Quick Quiz 15.6 */

2013-07-03T22:47:53Z

Quick Quiz 15.6

← Older revision		Revision as of 22:47, 3 July 2013
Line 511:		Line 511:
	6. Record selection means that the sort must include all records.		6. Record selection means that the sort must include all records.

	~~Answer: <br>~~		[[Answers 15.6]] <br>
	1.~~) T <br>~~
	~~2.) F <br>~~
	~~3.) F <br>~~
	~~4.) T~~ <br>
	~~5.) T <br>~~
	~~6.) F~~

	===15.7 All about the PRESORT utility===		===15.7 All about the PRESORT utility===

Laura: /* Quick Quiz 15.5 */

2013-07-03T22:47:24Z

Quick Quiz 15.5

← Older revision		Revision as of 22:47, 3 July 2013
Line 473:		Line 473:
	4. When a file is opened with the keyword RELATIVE, after a record has been read, it is more efficient to use a REWRITE statement without a REC= clause (as opposed to a REWRITE statement with a REC= clause) to make changes in the record.		4. When a file is opened with the keyword RELATIVE, after a record has been read, it is more efficient to use a REWRITE statement without a REC= clause (as opposed to a REWRITE statement with a REC= clause) to make changes in the record.

	~~Answer: <br>~~		[[Answers 15.5]] <br>
	~~1.) T <br>~~
	~~2.) T <br>~~
	3.~~) T~~ <br>
	~~4.) T~~

	===15.6 Introducing the SORT command and the PRESORT utility===		===15.6 Introducing the SORT command and the PRESORT utility===

Laura: /* Quick Quiz 15.4 */

2013-07-03T22:46:46Z

Quick Quiz 15.4

← Older revision		Revision as of 22:46, 3 July 2013
Line 370:		Line 370:
	8. The NOREC error condition can occur on READ, DELETE, REWRITE, and RESTORE statements.		8. The NOREC error condition can occur on READ, DELETE, REWRITE, and RESTORE statements.

	~~Answer: <br>~~		[[Answers 15.4]] <br>
	1.~~) F <br>~~
	~~2.) F <br>~~
	~~3.) F <br>~~
	4~~.) T <br>~~
	~~5.) F <br>~~
	~~6.) T <br>~~
	~~7.) T <br>~~
	~~8.) T~~ <br>

	===15.5 Relative processing: A sample program===		===15.5 Relative processing: A sample program===

Laura: /* Quick Quiz 15.3 */

2013-07-03T22:46:15Z

Quick Quiz 15.3

← Older revision		Revision as of 22:46, 3 July 2013
Line 192:		Line 192:
	====Quick Quiz 15.3====		====Quick Quiz 15.3====
	1. Two of the following six READ statements use improper syntax for relative file processing; which are they? <br>		1. Two of the following six READ statements use improper syntax for relative file processing; which are they? <br>

	a) 00010 READ #45,REC=12,USING FORMT:EGGROLL <br>		a) 00010 READ #45,REC=12,USING FORMT:EGGROLL <br>
	b) 00020 READ #7,USING AG,REC=85-N*46+T:INSINK <br>		b) 00020 READ #7,USING AG,REC=85-N*46+T:INSINK <br>
Line 200:		Line 201:

	2. When file #3 is open for relative processing and Business Rules! executes the following statement, which record will be read? <br>		2. When file #3 is open for relative processing and Business Rules! executes the following statement, which record will be read? <br>

	00030 READ #3,USING 40,REC=15:PLASMA,DONOR$,BLDTYPE$		00030 READ #3,USING 40,REC=15:PLASMA,DONOR$,BLDTYPE$
	a) The first record in the file. <br>		a) The first record in the file. <br>
Line 207:		Line 209:

	3. Which I/O statement(s) never use(s) a REC= clause? <br>		3. Which I/O statement(s) never use(s) a REC= clause? <br>

	a) REWRITE <br>		a) REWRITE <br>
	b) READ <br>		b) READ <br>
Line 215:		Line 218:

	4. What happens when a READ statement without a REC= clause is used on a file opened for relative processing? <br>		4. What happens when a READ statement without a REC= clause is used on a file opened for relative processing? <br>

	a) The last record in the file is accessed. <br>		a) The last record in the file is accessed. <br>
	b) The system reads the next sequential record. <br>		b) The system reads the next sequential record. <br>
Line 220:		Line 224:

	5. What systems function can you use to find out the last record number in an internal file? <br>		5. What systems function can you use to find out the last record number in an internal file? <br>

	a) RECL(filenum) <br>		a) RECL(filenum) <br>
	b) LREC(filenum) <br>		b) LREC(filenum) <br>
	c) RECNUM(filenum)		c) RECNUM(filenum)

	~~Answer: <br>~~		[[Answers 15.3]] <br>
	1.~~) a and d <br>~~
	~~2.) c <br>~~
	3~~.) d <br>~~
	~~4.) b <br>~~
	~~5.) b~~ <br>

	===15.4 Using I/O statements with RELATIVE processing===		===15.4 Using I/O statements with RELATIVE processing===