Global: ^DD("KEY"

Information

FileMan FileNo	FileMan Filename	Package
.31	KEY	VA FileMan

Description

This file stores information about keys on a file or subfile. A key is a set of one or more fields that uniquely identifies a record in a file. If more than one set of fields can uniquely identify a record, one of those sets should be designated the primary key; all others should be designated secondary keys. The primary key is the principal means of identifying records in the file. To allow FileMan to enforce key uniqueness, the database designer must define a regular index that consists of all the fields that make up the key. This index is called the uniqueness index. All key fields must have values. They cannot be null.

Pointer To FileMan Files, Total: 1

Package	Total	FileMan Files
VA FileMan	1	INDEX(#.11)[3]

Fields, Total: 5

Field #	Name	Loc	Type	Details
.01	FILE	0;1	NUMBER	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:+X'=X!(X>999999999999)!(X<0)!(X?.E1"."8N.N) X` LAST EDITED: `JUN 11, 1998` HELP-PROMPT: `Type a Number between 0 and 999999999999, 7 Decimal Digits. Answer '??' for more help.` DESCRIPTION: `Answer should be the number of the file or subfile identified by this key. A file may have more than one key, but only one primary key.` CROSS-REFERENCE: `.31^B` `1)= S ^DD("KEY","B",$E(X,1,30),DA)=""` `2)= K ^DD("KEY","B",$E(X,1,30),DA)` `3)= Lets developers pick keys by their file number` `The B index on the .01 (File) of the Key file lets developers pick keys by the file whose records they uniquely distinguish.` RECORD INDEXES: `AP (#.3102), BB (#.3101)`
.02	NAME	0;2	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>1!($L(X)<1)!'(X?1U) X` LAST EDITED: `JAN 22, 1996` HELP-PROMPT: `Answer must be 1 upper case letter. Answer '??' for more help.` DESCRIPTION: `Answer must be the name of this key. The name of a file's primary key should be A, with subsequent keys for the same file named B, C, and so on.` RECORD INDEXES: `BB (#.3101)`
1	PRIORITY	0;3	SET	**********************REQUIRED FIELD********************** 'P' FOR PRIMARY; 'S' FOR SECONDARY; LAST EDITED: `JUL 25, 1997` HELP-PROMPT: `Answer '??' for more help.` DESCRIPTION: `Answer 'PRIMARY' if this is the primary key of the file, the key that will usually be used for identifying entries. Otherwise, answer 'SECONDARY'.` RECORD INDEXES: `AP (#.3102)`
2	FIELD	2;0	Multiple #.312	.312 LAST EDITED: `MAR 10, 1998` IDENTIFIED BY: `"WRITE": D EN^DDIOL(" "_$P(^(0),U,2),"","?0")` PRIMARY KEY: `A (#.31201)` `Uniqueness Index: BB (#.31201)` `File, Field: 1) FIELD (.312,.01) 2) FILE (.312,.02)` INDEXED BY: `FIELD & FILE (BB), SEQUENCE NUMBER & FIELD & FILE (S)`
3	UNIQUENESS INDEX	0;4	POINTER TO INDEX FILE (#.11)	INDEX(#.11) INPUT TRANSFORM: `S DIC("S")="I 1 Q:'$D(DDS)!'$D(DIKKEY) I $P(^(0),U,9)=$P(^DD(""KEY"",DIKKEY,0),U)" D ^DIC K DIC S DIC=DIE,X=+Y K:Y<0 X` LAST EDITED: `JUN 11, 1998` HELP-PROMPT: `Answer '??' for more help.` DESCRIPTION: `Answer with the index that FileMan should use to ensure that new key values are unique. It must be a new-style index that resides in the Index file, and must cross-reference the key fields in proper sequence.` SCREEN: `S DIC("S")="I 1 Q:'$D(DDS)!'$D(DIKKEY) I $P(^(0),U,9)=$P(^DD(""KEY"",DIKKEY,0),U)"` EXPLANATION: `Root File of Index must equal File of Key.` FIELD INDEX: `AU (#.3103) REGULAR IR SORTING ONLY` `Short Descr: Lets FileMan determine whether an index is a uniqueness index for a key` `Set Logic: S ^DD("KEY","AU",X,DA)=""` `Kill Logic: K ^DD("KEY","AU",X,DA)` `Whole Kill: K ^DD("KEY","AU")` `X(1): UNIQUENESS INDEX (.31,3) (Subscr 1) (forwards)`

Found Entries, Total: 148

FILE: .11	FILE: .114	FILE: .31	FILE: .312	FILE: 3.81	FILE: 20	FILE: 798	FILE: 798.1
FILE: 798.13	FILE: 798.128	FILE: 798.2	FILE: 798.02	FILE: 798.11	FILE: 8927.1	FILE: 161.45	FILE: 798.118
FILE: 798.129	FILE: 798.122	FILE: 801.04	FILE: 101.15	FILE: 810.2	FILE: 810.21	FILE: 798.26	FILE: 798.31
FILE: 810.4	FILE: 810.41	FILE: 798.9	FILE: 799.1	FILE: 799.22	FILE: 799.22	FILE: 712.5	FILE: 392.31
FILE: 799.31	FILE: 365.11	FILE: 810.7	FILE: 810.701	FILE: 810.8	FILE: 4.9999	FILE: 776.3	FILE: 776.5
FILE: 810.801	FILE: 799.34	FILE: 799.51	FILE: 810.9	FILE: 601.95	FILE: 344.73	FILE: 811.5	FILE: 130.4
FILE: 839.7	FILE: 757.5	FILE: 799.53	FILE: 811.7	FILE: 779.5	FILE: 142	FILE: 661.5	FILE: 8985.1
FILE: 8985.11	FILE: 414.02	FILE: 414.03	FILE: 414.04	FILE: 779.2	FILE: 779.21	FILE: 779.3	FILE: 779.4
FILE: 799.6	FILE: 799.61	FILE: 799.63	FILE: 799.64	FILE: 409.55	FILE: 18.05	FILE: 18.05	FILE: 420.14
FILE: 62.47	FILE: 164.18	FILE: 2005.88	FILE: 18.02	FILE: 18.12	FILE: 18.13	FILE: 2006.8	FILE: 2006.8
FILE: 702.01	FILE: 702.09	FILE: 704.001	FILE: 704.002	FILE: 704.006	FILE: 704.006	FILE: 704.007	FILE: 704.008
FILE: 704.101	FILE: 704.103	FILE: 704.104	FILE: 704.105	FILE: 704.106	FILE: 704.107	FILE: 704.108	FILE: 704.109
FILE: 704.111	FILE: 704.1111	FILE: 704.1112	FILE: 704.112	FILE: 704.1121	FILE: 704.1122	FILE: 704.1123	FILE: 704.113
FILE: 704.1131	FILE: 704.115	FILE: 704.116	FILE: 704.1161	FILE: 704.117	FILE: 704.118	FILE: 704.119	FILE: 704.121
FILE: 704.1211	FILE: 853.9	FILE: 802.4	FILE: 811.4	FILE: 8991.9	FILE: 364.8	FILE: 801.1	FILE: 2006.9192
FILE: .85	FILE: .85	FILE: 58.63	FILE: 58.64	FILE: 129.2	FILE: 129.21	FILE: 129.22	FILE: 129.23
FILE: 125	FILE: 125.11	FILE: 802.1	FILE: 802.2	FILE: 802.3	FILE: 8993	FILE: 8993.03	FILE: 801.46
FILE: 801.48	FILE: 811.8	FILE: 9999999.27	FILE: 811.6	FILE: 101.45	FILE: 801.41	FILE: 811.2	FILE: 811.23
FILE: 811.9	FILE: 9999999.09	FILE: 9999999.15	FILE: 9999999.64

Customize PDF page

Package: VA FileMan

Global: ^DD("KEY"

Information

Description

Pointer To FileMan Files, Total: 1

Fields, Total: 5

Found Entries, Total: 148