Key Spec: Difference between revisions
 (Created page with "The "key-spec" parameter indicates that the starting key positions and key lengths for up to six sections of a record are to be inserted at this point in the syntax. The follo...")  | 
				|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
===Key Spec Syntax===  | ===Key Spec Syntax===  | ||
 [, KPS=<starting pos>[/...] , KLN=<length>[/...]]  | |||
[[Image:Keyspec.png|700px]]  | [[Image:Keyspec.png|700px]]  | ||
This syntax can be inserted where 'key-spec' is specified in a statement's main syntax. Key Spec indicates the starting positions and lengths of up to six different key sections in a record. This parameter can be used only when the program is to create a new master file and a new index file. It is not necessary for the key sections to be adjacent to one another, but they may not exceed a combined length of more than 128 bytes.    | This syntax can be inserted where 'key-spec' is specified in a statement's main syntax. Key Spec indicates the starting positions and lengths of up to six different key sections in a record. This parameter can be used only when the program is to create a new master file and a new index file. It is not necessary for the key sections to be adjacent to one another, but they may not exceed a combined length of more than 128 bytes.    | ||
Within the key-spec syntax, the "KPS=" keyword may be followed by up to six "starting pos" specifications, each of which identifies the starting position of a key section; multiple specifications are separated by a forward slash. The "KLN=" keyword must be followed by the "length" parameter, which identifies the lengths of each of the key sections which were specified by the "starting pos" parameter.  | Within the key-spec syntax, the "KPS=" keyword may be followed by up to six "starting pos" specifications, each of which identifies the starting position of a key section; multiple specifications are separated by a forward slash.    | ||
The "KLN=" keyword must be followed by the "length" parameter, which identifies the lengths of each of the key sections which were specified by the "starting pos" parameter.  | |||
<noinclude>  | |||
[[Category:Definitions]]  | |||
</noinclude>  | |||
Latest revision as of 16:38, 5 May 2014
The "key-spec" parameter indicates that the starting key positions and key lengths for up to six sections of a record are to be inserted at this point in the syntax. The following syntax can be inserted wherever the "key-spec" parameter appears in a diagram:
Key Spec Syntax
[, KPS=<starting pos>[/...] , KLN=<length>[/...]]
This syntax can be inserted where 'key-spec' is specified in a statement's main syntax. Key Spec indicates the starting positions and lengths of up to six different key sections in a record. This parameter can be used only when the program is to create a new master file and a new index file. It is not necessary for the key sections to be adjacent to one another, but they may not exceed a combined length of more than 128 bytes.
Within the key-spec syntax, the "KPS=" keyword may be followed by up to six "starting pos" specifications, each of which identifies the starting position of a key section; multiple specifications are separated by a forward slash.
The "KLN=" keyword must be followed by the "length" parameter, which identifies the lengths of each of the key sections which were specified by the "starting pos" parameter.