Home Package List Routine Alphabetical List Global Alphabetical List FileMan Files List FileMan Sub-Files List Package Component Lists Package-Namespace Mapping

Info | Desc | Pointed To By FileMan Files | Pointer To FileMan Files | Fields

Print Page as PDF

Global: ^DMSQ("KF"

Package: VA FileMan

Global: ^DMSQ("KF"

Information

FileMan FileNo	FileMan Filename	Package
1.5213	SQLI_KEY_FORMAT	VA FileMan

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.

Pointed To By FileMan Files, Total: 1

Package	Total	FileMan Files
VA FileMan	1	SQLI_PRIMARY_KEY(#1.5218)[7]

Pointer To FileMan Files, Total: 1

Package	Total	FileMan Files
VA FileMan	1	SQLI_DATA_TYPE(#1.5211)[1]

Fields, Total: 5

Field #	Name	Loc	Type	Details
.01	KF_NAME	0;1	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `Answer must be 3-30 characters in length.` `WRITE AUTHORITY: ^` CROSS-REFERENCE: `1.5213^B` `1)= S ^DMSQ("KF","B",$E(X,1,30),DA)=""` `2)= K ^DMSQ("KF","B",$E(X,1,30),DA)`
1	KF_DATA_TYPE	0;2	POINTER TO SQLI_DATA_TYPE FILE (#1.5211)	**********************REQUIRED FIELD********************** SQLI_DATA_TYPE(#1.5211) LAST EDITED: `AUG 23, 1996` HELP-PROMPT: `Enter the ODBC data type of this key` `WRITE AUTHORITY: ^` CROSS-REFERENCE: `1.5213^C` `1)= S ^DMSQ("KF","C",$E(X,1,30),DA)=""` `2)= K ^DMSQ("KF","C",$E(X,1,30),DA)` `KEY FORMAT BY DATA TYPE`
2	KF_COMMENT	0;3	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>60!($L(X)<3) X` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `Answer must be 3-60 characters in length.` `WRITE AUTHORITY: ^`
3	KF_INT_EXPR	1;E1,245	MUMPS	INPUT TRANSFORM: `K:$L(X)>245 X D:$D(X) ^DIM` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `This is Standard MUMPS code.` DESCRIPTION: `An M expression which converts X to it's key format` `WRITE AUTHORITY: ^`
4	KF_INT_EXEC	2;E1,245	MUMPS	INPUT TRANSFORM: `K:$L(X)>245 X D:$D(X) ^DIM` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `This is Standard MUMPS code.` DESCRIPTION: `A line of M code which converts X to its key format` `WRITE AUTHORITY: ^`

Info | Desc | Pointed To By FileMan Files | Pointer To FileMan Files | Fields