| 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
 | 
|---|