Files > SQLI_KEY_FORMAT

name

SQLI_KEY_FORMAT

number

1.5213

location

^DMSQ("KF",

description

Strategies for converting base values into key values. Soundex and upper case conversion are common examples. This implies that comparisons of key values with base values must be preceded by conversion of the base value to key value. Key formats are frequently lossy; they can't be converted uniquely back to base format.

Fields

#	Name	Location	Type	Details	Index	Description
.01	kf name(+)	0;1	FREE TEXT		B
1	kf data type(+)	0;2	POINTER	1.5211	C
2	kf comment	0;3	FREE TEXT
3	kf int expr	1;E1,245	FREE TEXT			An M expression which converts X to it's key format
4	kf int exec	2;E1,245	FREE TEXT			A line of M code which converts X to its key format