Chapter 15 - Revision history

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===

Laura: /* Quick Quiz 15.2 */

2013-07-03T22:45:39Z

Quick Quiz 15.2

← Older revision		Revision as of 22:45, 3 July 2013
Line 103:		Line 103:
	====Quick Quiz 15.2====		====Quick Quiz 15.2====
	1. Which I/O statements can be used on a file opened for OUTPUT? <br>		1. Which I/O statements can be used on a file opened for OUTPUT? <br>

	a) READ <br>		a) READ <br>
	b) REREAD <br>		b) REREAD <br>
Line 111:		Line 112:

	2. Which I/O statements can be used on a file opened for INPUT? <br>		2. Which I/O statements can be used on a file opened for INPUT? <br>

	a) READ <br>		a) READ <br>
	b) REREAD <br>		b) REREAD <br>
Line 119:		Line 121:

	3. Which I/O statements can be used in a file opened for OUTIN? <br>		3. Which I/O statements can be used in a file opened for OUTIN? <br>

	a) READ <br>		a) READ <br>
	b) REREAD <br>		b) REREAD <br>
Line 134:		Line 137:
	9. Any I/O statement can be used without error when a file is opened OUTIN.		9. Any I/O statement can be used without error when a file is opened OUTIN.

	~~Answer <br>~~		[[Answers 15.2]] <br>
	1. ~~DELETE, RESTORE, and WRITE <br>~~
	2~~. RESTORE, READ, and REREAD <br>~~
	~~3. All I/O statements <br>~~
	~~4. False <br>~~
	~~5. True <br>~~
	~~6. True <br>~~
	~~7. False <br>~~
	~~8. True <br>~~
	~~9. True~~ <br>

	===15.3 The REC= clause===		===15.3 The REC= clause===