1 | DINIT2AA ;SFISC/MKO-DATA FOR KEY AND INDEX FILES ;10:50 AM 30 Mar 1999
|
---|
2 | ;;22.0;VA FileMan;;Mar 30, 1999
|
---|
3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
---|
4 | F I=1:2 S X=$T(ENTRY+I) G:X="" ^DINIT2AB S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y
|
---|
5 | Q
|
---|
6 | ENTRY ;
|
---|
7 | ;;^DD("IX",.001,0)
|
---|
8 | ;;=0^ADEL^Delete Keys and Indexes associated with a deleted field.^MU^^F^R^I^0^^^^^A
|
---|
9 | ;;^DD("IX",.001,1)
|
---|
10 | ;;=Q
|
---|
11 | ;;^DD("IX",.001,2)
|
---|
12 | ;;=D:'$D(DICATTED)&'$D(DIU) DELXRF^DICATT4(DA(1),DA)
|
---|
13 | ;;^DD("IX",.1101,0)
|
---|
14 | ;;=.11^BB^The uniqueness index for the primary key of the Index file^R^^R^IR^I^.11^^^^^LS
|
---|
15 | ;;^DD("IX",.1101,.1,0)
|
---|
16 | ;;=^^3^3^2980611^
|
---|
17 | ;;^DD("IX",.1101,.1,1,0)
|
---|
18 | ;;=The BB index, on the key of the Index file, lets FileMan test potential
|
---|
19 | ;;^DD("IX",.1101,.1,2,0)
|
---|
20 | ;;=key values for uniqueness. It is a regular compound index with two fields,
|
---|
21 | ;;^DD("IX",.1101,.1,3,0)
|
---|
22 | ;;=the .01 (File) and .02 (Index Name).
|
---|
23 | ;;^DD("IX",.1101,1)
|
---|
24 | ;;=S ^DD("IX","BB",X(1),X(2),DA)=""
|
---|
25 | ;;^DD("IX",.1101,2)
|
---|
26 | ;;=K ^DD("IX","BB",X(1),X(2),DA)
|
---|
27 | ;;^DD("IX",.1101,2.5)
|
---|
28 | ;;=K ^DD("IX","BB")
|
---|
29 | ;;^DD("IX",.1101,11.1,0)
|
---|
30 | ;;=^.114^2^2
|
---|
31 | ;;^DD("IX",.1101,11.1,1,0)
|
---|
32 | ;;=1^F^.11^.01^^1
|
---|
33 | ;;^DD("IX",.1101,11.1,2,0)
|
---|
34 | ;;=2^F^.11^.02^^2
|
---|
35 | ;;^DD("IX",.1102,0)
|
---|
36 | ;;=.11^IX^Allows user to look up Indexes by Name.^R^^F^IR^I^.11^^^^^LS
|
---|
37 | ;;^DD("IX",.1102,.1,0)
|
---|
38 | ;;=^^2^2^2990303^
|
---|
39 | ;;^DD("IX",.1102,.1,1,0)
|
---|
40 | ;;=This 'Regular' index on the Name field (#.02) allows users to select an
|
---|
41 | ;;^DD("IX",.1102,.1,2,0)
|
---|
42 | ;;=index by its name.
|
---|
43 | ;;^DD("IX",.1102,1)
|
---|
44 | ;;=S ^DD("IX","IX",$E(X,1,30),DA)=""
|
---|
45 | ;;^DD("IX",.1102,2)
|
---|
46 | ;;=K ^DD("IX","IX",$E(X,1,30),DA)
|
---|
47 | ;;^DD("IX",.1102,2.5)
|
---|
48 | ;;=K ^DD("IX","IX")
|
---|
49 | ;;^DD("IX",.1102,11.1,0)
|
---|
50 | ;;=^.114IA^1^1
|
---|
51 | ;;^DD("IX",.1102,11.1,1,0)
|
---|
52 | ;;=1^F^.11^.02^30^1^F
|
---|
53 | ;;^DD("IX",.11401,0)
|
---|
54 | ;;=.114^BB^The uniqueness index of the Cross-Reference Values multiple of the Index file^R^^F^IR^I^.114^^^^^LS
|
---|
55 | ;;^DD("IX",.11401,1)
|
---|
56 | ;;=S ^DD("IX",DA(1),11.1,"BB",X,DA)=""
|
---|
57 | ;;^DD("IX",.11401,2)
|
---|
58 | ;;=K ^DD("IX",DA(1),11.1,"BB",X,DA)
|
---|
59 | ;;^DD("IX",.11401,2.5)
|
---|
60 | ;;=K ^DD("IX",DA(1),11.1,"BB")
|
---|
61 | ;;^DD("IX",.11401,11.1,0)
|
---|
62 | ;;=^.114IA^1^1
|
---|
63 | ;;^DD("IX",.11401,11.1,1,0)
|
---|
64 | ;;=1^F^.114^.01^^1
|
---|
65 | ;;^DD("IX",.11402,0)
|
---|
66 | ;;=.114^AC^Lets FileMan find cross reference values by subscript^R^^F^IR^I^.114^^^^^S
|
---|
67 | ;;^DD("IX",.11402,1)
|
---|
68 | ;;=S ^DD("IX",DA(1),11.1,"AC",X,DA)=""
|
---|
69 | ;;^DD("IX",.11402,2)
|
---|
70 | ;;=K ^DD("IX",DA(1),11.1,"AC",X,DA)
|
---|
71 | ;;^DD("IX",.11402,2.5)
|
---|
72 | ;;=K ^DD("IX",DA(1),11.1,"AC")
|
---|
73 | ;;^DD("IX",.11402,11.1,0)
|
---|
74 | ;;=^.114IA^1^1
|
---|
75 | ;;^DD("IX",.11402,11.1,1,0)
|
---|
76 | ;;=1^F^.114^.5^^1^F
|
---|
77 | ;;^DD("IX",.11403,0)
|
---|
78 | ;;=.11^F^Lets FileMan find the indexes affected when a field changes^R^^R^IR^W^.114^^^^^LS
|
---|
79 | ;;^DD("IX",.11403,.1,0)
|
---|
80 | ;;=^^6^6^2970303^^
|
---|
81 | ;;^DD("IX",.11403,.1,1,0)
|
---|
82 | ;;=The F index, is a whole file compound cross-reference on two fields in the
|
---|
83 | ;;^DD("IX",.11403,.1,2,0)
|
---|
84 | ;;=Cross-Reference Values multiple: File (#2) and Field (#3). It lets FileMan
|
---|
85 | ;;^DD("IX",.11403,.1,3,0)
|
---|
86 | ;;=identify the indexes that might be affected when a field value changes.
|
---|
87 | ;;^DD("IX",.11403,.1,4,0)
|
---|
88 | ;;=The checking of this index is an essential step during field level
|
---|
89 | ;;^DD("IX",.11403,.1,5,0)
|
---|
90 | ;;=transactions in building the list of record level cross-references that
|
---|
91 | ;;^DD("IX",.11403,.1,6,0)
|
---|
92 | ;;=must be fired after user-driven changes to the record are finished.
|
---|
93 | ;;^DD("IX",.11403,1)
|
---|
94 | ;;=S ^DD("IX","F",X(1),X(2),DA(1),DA)=""
|
---|
95 | ;;^DD("IX",.11403,2)
|
---|
96 | ;;=K ^DD("IX","F",X(1),X(2),DA(1),DA)
|
---|
97 | ;;^DD("IX",.11403,2.5)
|
---|
98 | ;;=K ^DD("IX","F")
|
---|
99 | ;;^DD("IX",.11403,11.1,0)
|
---|
100 | ;;=^.114^2^2
|
---|
101 | ;;^DD("IX",.11403,11.1,1,0)
|
---|
102 | ;;=1^F^.114^2^^1
|
---|
103 | ;;^DD("IX",.11403,11.1,2,0)
|
---|
104 | ;;=2^F^.114^3^^2
|
---|
105 | ;;^DD("IX",.3101,0)
|
---|
106 | ;;=.31^BB^The uniqueness index for the Key file^R^^R^IR^I^.31^^^^^LS
|
---|
107 | ;;^DD("IX",.3101,.1,0)
|
---|
108 | ;;=^^3^3^2970314^^^^
|
---|
109 | ;;^DD("IX",.3101,.1,1,0)
|
---|
110 | ;;=The BB index, the uniqueness index for the Key file's key, lets FileMan
|
---|
111 | ;;^DD("IX",.3101,.1,2,0)
|
---|
112 | ;;=test potential key values for uniqueness. It is a regular compound index
|
---|
113 | ;;^DD("IX",.3101,.1,3,0)
|
---|
114 | ;;=with two fields, the .01 (File) and .02 (Key Name).
|
---|
115 | ;;^DD("IX",.3101,1)
|
---|
116 | ;;=S ^DD("KEY","BB",X(1),X(2),DA)=""
|
---|
117 | ;;^DD("IX",.3101,2)
|
---|
118 | ;;=K ^DD("KEY","BB",X(1),X(2),DA)
|
---|
119 | ;;^DD("IX",.3101,2.5)
|
---|
120 | ;;=K ^DD("KEY","BB")
|
---|
121 | ;;^DD("IX",.3101,11.1,0)
|
---|
122 | ;;=^.114^2^2
|
---|
123 | ;;^DD("IX",.3101,11.1,1,0)
|
---|
124 | ;;=1^F^.31^.01^^1
|
---|
125 | ;;^DD("IX",.3101,11.1,2,0)
|
---|
126 | ;;=2^F^.31^.02^^2
|
---|
127 | ;;^DD("IX",.3102,0)
|
---|
128 | ;;=.31^AP^Lets FileMan determine the primary key of a file^R^^R^IR^I^.31^^^^^S
|
---|
129 | ;;^DD("IX",.3102,1)
|
---|
130 | ;;=S ^DD("KEY","AP",X(1),X(2),DA)=""
|
---|
131 | ;;^DD("IX",.3102,1.4)
|
---|
132 | ;;=S X=X(2)="P"
|
---|
133 | ;;^DD("IX",.3102,2)
|
---|
134 | ;;=K ^DD("KEY","AP",X(1),X(2),DA)
|
---|
135 | ;;^DD("IX",.3102,2.4)
|
---|
136 | ;;=S X=X(2)="P"
|
---|
137 | ;;^DD("IX",.3102,2.5)
|
---|
138 | ;;=K ^DD("KEY","AP")
|
---|
139 | ;;^DD("IX",.3102,11.1,0)
|
---|
140 | ;;=^.114I^2^2
|
---|
141 | ;;^DD("IX",.3102,11.1,1,0)
|
---|
142 | ;;=1^F^.31^.01^^1
|
---|
143 | ;;^DD("IX",.3102,11.1,2,0)
|
---|
144 | ;;=2^F^.31^1^^2
|
---|
145 | ;;^DD("IX",.3103,0)
|
---|
146 | ;;=.31^AU^Lets FileMan determine whether an index is a uniqueness index for a key^R^^F^IR^I^.31^^^^^S
|
---|
147 | ;;^DD("IX",.3103,1)
|
---|
148 | ;;=S ^DD("KEY","AU",X,DA)=""
|
---|
149 | ;;^DD("IX",.3103,2)
|
---|
150 | ;;=K ^DD("KEY","AU",X,DA)
|
---|
151 | ;;^DD("IX",.3103,2.5)
|
---|
152 | ;;=K ^DD("KEY","AU")
|
---|
153 | ;;^DD("IX",.3103,11.1,0)
|
---|
154 | ;;=^.114IA^1^1
|
---|
155 | ;;^DD("IX",.3103,11.1,1,0)
|
---|
156 | ;;=1^F^.31^3^^1^F
|
---|
157 | ;;^DD("IX",.31201,0)
|
---|
158 | ;;=.312^BB^The uniqueness index for Field multiple of the Key file.^R^^R^IR^I^.312^^^^^LS
|
---|
159 | ;;^DD("IX",.31201,.1,0)
|
---|
160 | ;;=^^3^3^2970203^^
|
---|
161 | ;;^DD("IX",.31201,.1,1,0)
|
---|
162 | ;;=The BB index, on the key of the Field multiple of the Key file, lets
|
---|
163 | ;;^DD("IX",.31201,.1,2,0)
|
---|
164 | ;;=FileMan test potential key values for uniqueness. It is a regular compound
|
---|
165 | ;;^DD("IX",.31201,.1,3,0)
|
---|
166 | ;;=index with two fields, the .01 (Field) and .02 (File).
|
---|
167 | ;;^DD("IX",.31201,1)
|
---|
168 | ;;=S ^DD("KEY",DA(1),2,"BB",X(1),X(2),DA)=""
|
---|
169 | ;;^DD("IX",.31201,2)
|
---|
170 | ;;=K ^DD("KEY",DA(1),2,"BB",X(1),X(2),DA)
|
---|
171 | ;;^DD("IX",.31201,2.5)
|
---|
172 | ;;=K ^DD("KEY",DA(1),2,"BB")
|
---|
173 | ;;^DD("IX",.31201,11.1,0)
|
---|
174 | ;;=^.114^2^2
|
---|
175 | ;;^DD("IX",.31201,11.1,1,0)
|
---|
176 | ;;=1^F^.312^.01^^1
|
---|
177 | ;;^DD("IX",.31201,11.1,2,0)
|
---|
178 | ;;=2^F^.312^.02^^2
|
---|
179 | ;;^DD("IX",.31202,0)
|
---|
180 | ;;=.31^F^Lets FileMan find the Keys that include each field^R^^R^IR^W^.312^^^^^LS
|
---|
181 | ;;^DD("IX",.31202,.1,0)
|
---|
182 | ;;=^^4^4^2980911^
|
---|
183 | ;;^DD("IX",.31202,.1,1,0)
|
---|
184 | ;;=The F index, a whole file compound cross-reference on the key of the
|
---|
185 | ;;^DD("IX",.31202,.1,2,0)
|
---|
186 | ;;=Fields multiple of the Key file, lets FileMan determine the keys a field
|
---|
187 | ;;^DD("IX",.31202,.1,3,0)
|
---|
188 | ;;=is part of. This is essential for identifying the key value uniqueness
|
---|
189 | ;;^DD("IX",.31202,.1,4,0)
|
---|
190 | ;;=tests that must be done when a field value changes.
|
---|
191 | ;;^DD("IX",.31202,1)
|
---|
192 | ;;=S ^DD("KEY","F",X(1),X(2),DA(1),DA)=""
|
---|
193 | ;;^DD("IX",.31202,2)
|
---|
194 | ;;=K ^DD("KEY","F",X(1),X(2),DA(1),DA)
|
---|
195 | ;;^DD("IX",.31202,2.5)
|
---|
196 | ;;=K ^DD("KEY","F")
|
---|
197 | ;;^DD("IX",.31202,11.1,0)
|
---|
198 | ;;=^.114^2^2
|
---|
199 | ;;^DD("IX",.31202,11.1,1,0)
|
---|
200 | ;;=1^F^.312^.02^^1
|
---|
201 | ;;^DD("IX",.31202,11.1,2,0)
|
---|
202 | ;;=2^F^.312^.01^^2
|
---|