Syntax Explanation - Revision history

Gordon.dye at 19:40, 1 July 2019

2019-07-01T19:40:26Z

← Older revision		Revision as of 19:40, 1 July 2019
Line 7:		Line 7:
	*Items in [square brackets] are optional.		*Items in [square brackets] are optional.
	* [,...] indicates the preceding term can be repeated (comma separated).		* [,...] indicates the preceding term can be repeated (comma separated).
	*A bar \| within a braced group (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. One of the bar separated terms must be specified.		*A bar \| ''within a braced group'' (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. ''One of the bar separated terms must be specified.''
	*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<integer>, item descriptions are found in its link or subsequent lines.		*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<integer>, item descriptions are found in its link or subsequent lines.
	*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.		*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.
Line 27:		Line 27:
	===Example: Delete Statement===		===Example: Delete Statement===

	DELETE #<file number>[,REC=<numeric expression>\|,KEY=<string expression>][,RESERVE\|,RELEASE] : {<error condition> <line ref>,}		DELETE #<file number>[,REC=<numeric expression>\|,KEY=<string expression>][,RESERVE\|,RELEASE] : [<error condition> <line ref> [, ...]]

	numeric expression		numeric expression
Line 54:		Line 54:

	string expression		string expression
	<string internal function>\|<string user-defined function>\|<string constant>\|<string variable> {<substring operations>~~} {~~<concatenation operations>}		<string internal function>\|<string user-defined function>\|<string constant>\|<string variable> [<substring operations>] [<concatenation operations>]

	string internal function		string internal function

Laura at 00:11, 6 May 2014

2014-05-06T00:11:11Z

← Older revision		Revision as of 00:11, 6 May 2014
Line 8:		Line 8:
	* [,...] indicates the preceding term can be repeated (comma separated).		* [,...] indicates the preceding term can be repeated (comma separated).
	*A bar \| within a braced group (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. One of the bar separated terms must be specified.		*A bar \| within a braced group (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. One of the bar separated terms must be specified.
	*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<~~file number~~>, item descriptions are found in its link or subsequent lines.		*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<integer>, item descriptions are found in its link or subsequent lines.
	*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.		*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.
	*Spaces between items mean one or more space is required.		*Spaces between items mean one or more space is required.

Laura at 14:52, 29 April 2014

2014-04-29T14:52:59Z

← Older revision		Revision as of 14:52, 29 April 2014
Line 8:		Line 8:
	* [,...] indicates the preceding term can be repeated (comma separated).		* [,...] indicates the preceding term can be repeated (comma separated).
	*A bar \| within a braced group (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. One of the bar separated terms must be specified.		*A bar \| within a braced group (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. One of the bar separated terms must be specified.
	*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in subsequent lines.		*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in its link or subsequent lines.
	*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.		*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.
	*Spaces between items mean one or more space is required.		*Spaces between items mean one or more space is required.

Laura: /* Example: Delete Statement */

2014-04-26T02:27:26Z

Example: Delete Statement

← Older revision		Revision as of 02:27, 26 April 2014
Line 50:		Line 50:
	\|<string expression> <comparison operator> <string expression>		\|<string expression> <comparison operator> <string expression>
	\|<string expression><comparison operator><string expression> {AND\|OR} [NOT]<string expression><comparison operator><string expression>}		\|<string expression><comparison operator><string expression> {AND\|OR} [NOT]<string expression><comparison operator><string expression>}

			Conditional expressions evaluate to a boolean numerical value where zero is regarded as false and non-zero is regarded as true. Parentheses, of course, are significant and affect the order of processing. Additional parentheses (properly specified) can be used for visual clarity with no affect on performance.

	string expression		string expression

Laura: /* Example: Delete Statement */

2014-04-26T02:17:19Z

Example: Delete Statement

← Older revision		Revision as of 02:17, 26 April 2014
Line 30:		Line 30:

	numeric expression		numeric expression
	~~<conditional expression>\|~~<number>\|<numeric variable>\|<numeric internal function>\|<numeric user-defined function>		<number>\|<numeric variable>\|<numeric internal function>\|<numeric user-defined function>\|<conditional expression>

	~~conditional expression~~
	~~<number> <numeric operator> <number>~~
	\|<~~numeric expression> <numeric operator> <numeric expression>~~
	~~\|<numeric expression> <numeric operator> <numeric expression>{AND <numeric expression> <numeric operator> <numeric expression} {OR <numeric~~ expression> ~~<numeric operator> <numeric expression>}~~
	~~\|<value> <comparison operator> <value>~~
	~~\|<value><comparison operator><value> {AND <value><comparison operator><value>} {OR <value><comparison operator><value>} {NOT <value><comparison operator><value>}~~

	number		number
Line 46:		Line 39:

	numeric internal function		numeric internal function
	<An [[:Category:Internal Functions\|internal function]] ~~with~~ a numeric value>		<An [[:Category:Internal Functions\|internal function]] which produces a numeric value>

	numeric user-defined function		numeric user-defined function
	<~~One with~~ a numeric value>		<A user defined function that returns a numeric value>

			conditional expression
			<number> <comparison operator> <number>
			\|<numeric expression> <comparison operator> <numeric expression>
			\|<numeric expression> <comparison operator> <numeric expression> {AND\|OR} <conditional expression>
			\|<string expression> <comparison operator> <string expression>
			\|<string expression><comparison operator><string expression> {AND\|OR} [NOT]<string expression><comparison operator><string expression>}


	string expression		string expression

Laura at 01:59, 26 April 2014

2014-04-26T01:59:20Z

← Older revision		Revision as of 01:59, 26 April 2014
Line 6:		Line 6:
	*Although the keywords are uppercase in the diagrams, they may be specified in upper, lower or mixed case.		*Although the keywords are uppercase in the diagrams, they may be specified in upper, lower or mixed case.
	*Items in [square brackets] are optional.		*Items in [square brackets] are optional.
	*~~Items in~~ {braces~~} can~~ be ~~repeated multiple times~~.		* [,...] indicates the preceding term can be repeated (comma separated).
			*A bar \| within a braced group (e.g. {aaa\|bbb} )signifies OR, meaning the braces enclose a bar separated list. One of the bar separated terms must be specified.
	*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in subsequent lines.		*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in subsequent lines.
	*Punctuation must be ~~used,~~ i.e. quotation marks, commas, colons etc.		*Punctuation, other than "{}, [], <> and ...", must be specified - i.e. quotation marks, commas, colons etc.
	*Spaces between items mean one or more space is required.		*Spaces between items mean one or more space is required.
	*Additional spaces may be specified ahead of or following commas.		*Additional spaces may be specified ahead of or following commas.
	*Commas or semi-colons ahead of closing braces must be specified only between repeating terms.
	*A bar \| signifies OR, meaning the item preceding the bar can be replaced with the item following it. For example:

	blue black\|grey\|white red pink\|orange		Example:
			blue {black\|grey\|white} red {pink\|orange}

	Satisfactory outcomes would be:		Satisfactory outcomes would be:

Laura at 18:36, 24 April 2014

2014-04-24T18:36:03Z

← Older revision		Revision as of 18:36, 24 April 2014
Line 11:		Line 11:
	*Spaces between items mean one or more space is required.		*Spaces between items mean one or more space is required.
	*Additional spaces may be specified ahead of or following commas.		*Additional spaces may be specified ahead of or following commas.
	*Commas ahead of closing braces must be specified only between repeating terms.		*Commas or semi-colons ahead of closing braces must be specified only between repeating terms.
	*A bar \| signifies OR, meaning the item preceding the bar can be replaced with the item following it. For example:		*A bar \| signifies OR, meaning the item preceding the bar can be replaced with the item following it. For example:

Laura at 18:13, 24 April 2014

2014-04-24T18:13:00Z

← Older revision		Revision as of 18:13, 24 April 2014
Line 6:		Line 6:
	*Although the keywords are uppercase in the diagrams, they may be specified in upper, lower or mixed case.		*Although the keywords are uppercase in the diagrams, they may be specified in upper, lower or mixed case.
	*Items in [square brackets] are optional.		*Items in [square brackets] are optional.
	*Items in {braces} can be repeated ~~0 or more~~ times.		*Items in {braces} can be repeated multiple times.
	*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in subsequent lines.		*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in subsequent lines.
	*Punctuation must be used, i.e. quotation marks, commas, colons etc.		*Punctuation must be used, i.e. quotation marks, commas, colons etc.

Laura at 17:45, 23 April 2014

2014-04-23T17:45:20Z

← Older revision		Revision as of 17:45, 23 April 2014
Line 7:		Line 7:
	*Items in [square brackets] are optional.		*Items in [square brackets] are optional.
	*Items in {braces} can be repeated 0 or more times.		*Items in {braces} can be repeated 0 or more times.
	*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. <#file number>, item descriptions are found in subsequent lines.		*Terms in <angle brackets> must be replaced with appropriate items. When not inherently logical i.e. #<file number>, item descriptions are found in subsequent lines.
	*Punctuation must be used, i.e. quotation marks, commas, colons etc.		*Punctuation must be used, i.e. quotation marks, commas, colons etc.
	*Spaces between items mean one or more space is required.		*Spaces between items mean one or more space is required.

Laura: /* Example: Delete Statement */

2014-04-18T19:21:27Z

Example: Delete Statement

← Older revision		Revision as of 19:21, 18 April 2014
Line 34:		Line 34:
	conditional expression		conditional expression
	<number> <numeric operator> <number>		<number> <numeric operator> <number>
	<numeric expression> <numeric operator> <numeric expression>		\|<numeric expression> <numeric operator> <numeric expression>
	<numeric expression> <numeric operator> <numeric expression>{AND <numeric expression> <numeric operator> <numeric expression} {OR <numeric expression> <numeric operator> <numeric expression>}		\|<numeric expression> <numeric operator> <numeric expression>{AND <numeric expression> <numeric operator> <numeric expression} {OR <numeric expression> <numeric operator> <numeric expression>}
	<value> <comparison operator> <value>		\|<value> <comparison operator> <value>
	<value><comparison operator><value> {AND <value><comparison operator><value>} {OR <value><comparison operator><value>} {NOT <value><comparison operator><value>}		\|<value><comparison operator><value> {AND <value><comparison operator><value>} {OR <value><comparison operator><value>} {NOT <value><comparison operator><value>}

	number		number