KLn - Revision history

Gabriel at 20:29, 17 December 2021

2021-12-17T20:29:50Z

← Older revision		Revision as of 20:29, 17 December 2021
Line 1:		Line 1:

	KLN(<file ~~name~~>[,<[[numeric expression]]>])		KLN(<file number>[,<[[numeric expression]]>])

	The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file ~~name~~'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.		The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file number'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.

	====Comments and Examples====		====Comments and Examples====

Laura at 17:23, 22 May 2014

2014-05-22T17:23:58Z

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

	~~KLn~~(<file name>[,<[[numeric expression]]>])		KLN(<file name>[,<[[numeric expression]]>])

	The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file name'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.		The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file name'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.

Laura at 19:40, 21 May 2014

2014-05-21T19:40:12Z

← Older revision		Revision as of 19:40, 21 May 2014
Line 1:		Line 1:

	KLn(<file name>[,<numeric expression>])		KLn(<file name>[,<[[numeric expression]]>])

	The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file name'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.		The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file name'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.

Laura at 19:40, 21 May 2014

2014-05-21T19:40:00Z

← Older revision		Revision as of 19:40, 21 May 2014
Line 1:		Line 1:

	KLn(N[,X])		KLn(<file name>[,<numeric expression>])

	The '''KLn''' [[internal function]] returns the key length in bytes for master file N. With an optional second parameter X, KLN can also return the length of a section of a key when split keys are used. When X is 2, the length of the second section of the key is returned.		The '''KLn''' [[internal function]] returns the key length in bytes for master file specified by 'file name'. With an optional second parameter, KLN can also return the length of a section of a key when split keys are used. When the numeric expression is 2, the length of the second section of the key is returned.

	====Comments and Examples====		====Comments and Examples====

John: moved KLN to KLn over redirect

2014-02-24T18:31:08Z

moved KLN to KLn over redirect

← Older revision	Revision as of 18:31, 24 February 2014
(No difference)

Mikhail.zheleznov: *

2012-01-26T17:57:21Z

← Older revision		Revision as of 17:57, 26 January 2012
Line 5:		Line 5:

	====Comments and Examples====		====Comments and Examples====

	Here is an example to illustrate the use of the optional second parameter for a key file with split keys. In line 1000, file #1 is opened with a key split into three parts. This line replaces the existing master file and the existing key file with newly created empty master and key files.		Here is an example to illustrate the use of the optional second parameter for a key file with split keys. In line 1000, file #1 is opened with a key split into three parts. This line replaces the existing master file and the existing key file with newly created empty master and key files.

	01000 OPEN #1: "NAME=data,replace,recl=80,KFNAME=key,KPS=70/40/60,KLN=6/7/8", INTERNAL,OUTIN,KEYED		01000 OPEN #1: "NAME=data,replace,recl=80,KFNAME=key,KPS=70/40/60,KLN=6/7/8",INTERNAL,OUTIN,KEYED

	The optional second parameter of the KLN function specifies the key field number when there are split keys. Listed below are values that can be returned by the KLN function after the above OPEN statement for a key field composed of three separate fields:		The optional second parameter of the KLN function specifies the key field number when there are split keys. Listed below are values that can be returned by the KLN function after the above OPEN statement for a key field composed of three separate fields:

	KLN(1) = 21		KLN(1) = 21
	KLN(1,1) = 6		KLN(1,1) = 6
Line 21:		Line 23:
	The KLN function returns -1 when the file is not open or the master file has no key file. An invalid key field number will also return -1. For example, KLN(1,4) returns -1 because this file was opened with only three key fields. This result occurs whenever the specified field number is bigger than the number of fields used.		The KLN function returns -1 when the file is not open or the master file has no key file. An invalid key field number will also return -1. For example, KLN(1,4) returns -1 because this file was opened with only three key fields. This result occurs whenever the specified field number is bigger than the number of fields used.

	====Related Functions:====		====Related Functions====

	*[[EXISTS]]		*[[EXISTS]]
	*[[FILE$]]		*[[FILE$]]
Line 31:		Line 34:
	*[[Rec]]		*[[Rec]]
	*[[RLn]]		*[[RLn]]
	*[[Open Internal]]


	<noinclude>		<noinclude>
	[[Category:Internal Functions]]		[[Category:Internal Functions]]
	</noinclude>		</noinclude>

Mikhail.zheleznov: moved KLn to KLN

2012-01-17T09:08:35Z

moved KLn to KLN

← Older revision	Revision as of 09:08, 17 January 2012
(No difference)

Mikhail.zheleznov: 1 revision

2012-01-15T14:11:52Z

1 revision

New page

KLn(N[,X])

The '''KLn''' [[internal function]] returns the key length in bytes for master file N. With an optional second parameter X, KLN can also return the length of a section of a key when split keys are used. When X is 2, the length of the second section of the key is returned.

====Comments and Examples====
Here is an example to illustrate the use of the optional second parameter for a key file with split keys. In line 1000, file #1 is opened with a key split into three parts. This line replaces the existing master file and the existing key file with newly created empty master and key files.

01000 OPEN #1: "NAME=data,replace,recl=80,KFNAME=key,KPS=70/40/60,KLN=6/7/8", INTERNAL,OUTIN,KEYED

The optional second parameter of the KLN function specifies the key field number when there are split keys. Listed below are values that can be returned by the KLN function after the above OPEN statement for a key field composed of three separate fields:
KLN(1) = 21
KLN(1,1) = 6
KLN(1,0) = 21
KLN(1,2) = 7
KLN(1,4) = -1
KLN(1,3) = 8

KLN(1) returns 21 because it returns the total combined length of the separate key fields for the key file (the key lengths of 6, 7 and 8 are added). Notice that when the second parameter is zero, the result is the same as when the second parameter is omitted. KLN(1,0) is equivalent to KLN(1).

The KLN function returns -1 when the file is not open or the master file has no key file. An invalid key field number will also return -1. For example, KLN(1,4) returns -1 because this file was opened with only three key fields. This result occurs whenever the specified field number is bigger than the number of fields used.

====Related Functions:====
*[[EXISTS]]
*[[FILE$]]
*[[FILENUM]]
*[[FREESP]]
*[[KPs]]
*[[KRec]]
*[[LRec]]
*[[Rec]]
*[[RLn]]
*[[Open Internal]]

<noinclude>
[[Category:Internal Functions]]
</noinclude>