Read file - Revision history

Gordon.dye: /* Syntax */

2018-08-10T16:32:53Z

Syntax

← Older revision		Revision as of 16:32, 10 August 2018
Line 17:		Line 17:

	===Syntax===		===Syntax===
	READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC=]]<[[numeric expression]]>]\|[, [[Pos Parameter\|POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :		READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [, [[KEYONLY]] ] {[, [[KEY]]{=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC=]]<[[numeric expression]]>]\|[, [[Pos Parameter\|POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :
	[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]		[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]
	[[file:Readfile.png\|900px]]		[[file:Readfile.png\|900px]]

Gordon.dye at 16:25, 10 August 2018

2018-08-10T16:25:05Z

← Older revision		Revision as of 16:25, 10 August 2018
Line 40:		Line 40:
	READ file provides error processing through the optional "error-cond line-ref" parameter. See [[Error Conditions]] for more information.		READ file provides error processing through the optional "error-cond line-ref" parameter. See [[Error Conditions]] for more information.

	====Positional parameters====		===Positional parameters===
	{{:Positional Parameters}}		{{:Positional Parameters}}

John at 18:07, 11 January 2016

2016-01-11T18:07:10Z

← Older revision		Revision as of 18:07, 11 January 2016
Line 45:		Line 45:
	===KEYONLY===		===KEYONLY===

	{{:~~KEYONLY~~}}		{{:KeyOnly}}

	===LINK=string===		===LINK=string===

Laura: /* Syntax */

2014-05-05T17:22:00Z

Syntax

← Older revision		Revision as of 17:22, 5 May 2014
Line 17:		Line 17:

	===Syntax===		===Syntax===
	READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC=]]<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :		READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC=]]<[[numeric expression]]>]\|[, [[Pos Parameter\|POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :
	[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]		[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]
	[[file:Readfile.png\|900px]]		[[file:Readfile.png\|900px]]

Laura: /* Syntax */

2014-05-05T17:20:38Z

Syntax

← Older revision		Revision as of 17:20, 5 May 2014
Line 17:		Line 17:

	===Syntax===		===Syntax===
	READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC]]=<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :		READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC=]]<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :
	[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]		[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]
	[[file:Readfile.png\|900px]]		[[file:Readfile.png\|900px]]

Laura: /* Syntax */

2014-05-05T17:19:53Z

Syntax

← Older revision		Revision as of 17:19, 5 May 2014
Line 17:		Line 17:

	===Syntax===		===Syntax===
	READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[SEARCH]] ]\|[, [[REC]]=<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :		READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[Index_Facility#Finding_records_with_the_KEY_and_SEARCH_parameters\|SEARCH]] ]\|[, [[REC]]=<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :
	[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]		[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]
	[[file:Readfile.png\|900px]]		[[file:Readfile.png\|900px]]

Laura: /* KEYONLY */

2014-05-05T17:17:16Z

KEYONLY

← Older revision		Revision as of 17:17, 5 May 2014
Line 45:		Line 45:
	===KEYONLY===		===KEYONLY===

	~~The READ statement's~~ KEYONLY parameter allows you to read both the key and the record number in a keyed file without reading the corresponding record in the master file. This feature was implemented to return the key if the master file record is locked and is being read by key. It can also be used to obtain keys sequentially, without the overhead of reading the master file.		{{:KEYONLY}}

	The KEYONLY parameter is valid only for files opened INPUT KEYED or OUTIN KEYED. It may be used with positional parameters to specify the key that is to be read. If no positional parameter is specified, the next key will be read. FORM statements corresponding to the key length and B 4 for the record number should be used. If the record length of the master file is not at least four bytes more than the key length, the record number is not returned.

	Read file KEYONLY without having read a master record to allocate a buffer caused the task to hang. BR has always required a master record to be read before accessing a file KEYONLY. Now this error condition produces BR error [[0718]].

	~~While Business Rules reads only the key file when the KEYONLY parameter is used, it does move the file pointer in the master file to the position of the record just read.~~

	Note that it is very important to keep the key file updated if this feature is to be used. Otherwise, READ with the KEYONLY parameter could return an incorrect record in a situation where a master file record is deleted or rewritten after a READ with a REC= parameter.

	~~A REREAD, DELETE, or REWRITE following a READ with the KEYONLY parameter will return an error.~~

	===LINK=string===		===LINK=string===

Laura: /* Syntax */

2014-05-05T17:16:40Z

Syntax

← Older revision		Revision as of 17:16, 5 May 2014
Line 17:		Line 17:

	===Syntax===		===Syntax===
	READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [~~KEY ONLY~~] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[SEARCH]] ]\|[, [[REC]]=<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :		READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [ [[KEYONLY]] ] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[SEARCH]] ]\|[, [[REC]]=<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :
	[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]		[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]
	[[file:Readfile.png\|900px]]		[[file:Readfile.png\|900px]]

Laura: /* Positional parameters */

2014-05-05T17:15:26Z

Positional parameters

@@ Line 41: / Line 41: @@
 ====Positional parameters====
-These positional parameters can be used with the READ statement:
+{{:Positional Parameters}}
 ===KEYONLY===

Laura: /* Syntax */

2014-05-05T17:14:26Z

Syntax

← Older revision		Revision as of 17:14, 5 May 2014
Line 17:		Line 17:

	===Syntax===		===Syntax===
	READ #<file number> [, USING {<string expression>\|<line ref>}] [, <positional parameter>] [KEY ONLY] {[, KEY {=\|>=} <string expression>]\|[, SEARCH]\|[, REC=<numeric expression>]\|[, POS=<numeric expression>]} [, {RESERVE\|RELEASE}] :		READ #<[[file number]]> [, [[USING]] {<[[string expression]]>\|<[[line ref]]>}] [, <[[positional parameter]]>] [KEY ONLY] {[, [[KEY]] {=\|>=} <[[string expression]]>]\|[, [[SEARCH]] ]\|[, [[REC]]=<[[numeric expression]]>]\|[, [[POS]]=<[[numeric expression]]]]>]} [, {[[RESERVE]]\|[[RELEASE]]}] :
	[{Mat <array name>\|<variable name>}][,...] [<error condition> <line ref>][,...]		[{[[Mat]] <[[array name]]>\|<[[variable name]]>}][,...] [<[[error condition]]> <[[line ref]]>][,...]
	[[file:Readfile.png\|900px]]		[[file:Readfile.png\|900px]]