1 | DDUCHK4 ;SFISC/MKO-CHECK INDEXES ON FILE ;6:36 AM 28 Dec 2004
|
---|
2 | ;;22.0;VA FileMan;*130*;Mar 30, 1999
|
---|
3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
---|
4 | ;
|
---|
5 | INDEX(DDUCFI,DDUCFIX) ;Check and optionally fix structure of Index file entry
|
---|
6 | N DDUCIX
|
---|
7 | Q:'$G(DDUCFI) S DDUCFIX=$G(DDUCFIX)
|
---|
8 | ;
|
---|
9 | ;Loop through "B" index to find INDEXes that reside on this file
|
---|
10 | D WCHK
|
---|
11 | S DDUCIX=""
|
---|
12 | F S DDUCIX=$O(^DD("IX","B",DDUCFI,DDUCIX)) Q:DDUCIX="" D CHKIX
|
---|
13 | ;
|
---|
14 | ;Check "AC","BB", and "F" indexes
|
---|
15 | D CHKAC,CHKBB,CHKF
|
---|
16 | Q
|
---|
17 | ;
|
---|
18 | CHKIX ;Check Index DDUCIX found in "B" index
|
---|
19 | ;In:
|
---|
20 | ; DDUCIX = index #
|
---|
21 | ; DDUCFI = file #
|
---|
22 | ; DDUCFIX = flag to fix
|
---|
23 | N DDUCIX0,DDUCIXID,DDUCNM,DDUCRF,DDUCRV
|
---|
24 | S DDUCIXID=$$IXID(DDUCIX,"")
|
---|
25 | ;
|
---|
26 | ;Check that Index exists
|
---|
27 | I '$D(^DD("IX",DDUCIX)) D Q
|
---|
28 | . D WNOIX
|
---|
29 | . D:DDUCFIX KILL($NA(^DD("IX","B",DDUCFI,DDUCIX)))
|
---|
30 | ;
|
---|
31 | ;Check that index has a FILE
|
---|
32 | S DDUCIX0=$G(^DD("IX",DDUCIX,0))
|
---|
33 | I $P(DDUCIX0,U)="" D
|
---|
34 | . D WMS("FILE (#.01) for "_DDUCIXID)
|
---|
35 | . D:DDUCFIX FFILE
|
---|
36 | ;
|
---|
37 | ;Get Name
|
---|
38 | S DDUCNM=$P(DDUCIX0,U,2)
|
---|
39 | I DDUCNM]"" S DDUCIXID=$$IXID(DDUCIX,DDUCNM)
|
---|
40 | E D WMS("NAME for "_DDUCIXID)
|
---|
41 | ;
|
---|
42 | ;Check Root File not null, and "AC" index exists
|
---|
43 | S DDUCRF=$P(DDUCIX0,U,9)
|
---|
44 | I 'DDUCRF D
|
---|
45 | . D WMS("ROOT FILE for "_DDUCIXID)
|
---|
46 | . D:DDUCFIX FRF
|
---|
47 | ;
|
---|
48 | ;Check Cross-Reference Values multiple
|
---|
49 | S DDUCRV=0
|
---|
50 | F S DDUCRV=$O(^DD("IX",DDUCIX,11.1,DDUCRV)) Q:'DDUCRV D CRV
|
---|
51 | ;
|
---|
52 | ;Reindex Index file entry
|
---|
53 | I DDUCFIX D
|
---|
54 | . N DIC,DIK,DA,X
|
---|
55 | . S DIK="^DD(""IX"",",DA=DDUCIX
|
---|
56 | . D IX^DIK
|
---|
57 | Q
|
---|
58 | ;
|
---|
59 | CRV ;Check a Cross-Reference Value
|
---|
60 | ;In:
|
---|
61 | ; DDUCIX = Index #
|
---|
62 | ; DDUCRV = CRV #
|
---|
63 | ; DDUCFIX = Flag to fix
|
---|
64 | ; DDUCRF = Root file #
|
---|
65 | ; DDUCIXID = String that identifies Index
|
---|
66 | N DDUCFIL,DDUCFLD,DDUCGL,DDUCOID,DDUCORD,DDUCRV0
|
---|
67 | ;
|
---|
68 | S DDUCRV0=$G(^DD("IX",DDUCIX,11.1,DDUCRV,0))
|
---|
69 | Q:$P(DDUCRV0,U,2)="C"
|
---|
70 | S DDUCORD=$P(DDUCRV0,U),DDUCFIL=$P(DDUCRV0,U,3),DDUCFLD=$P(DDUCRV0,U,4)
|
---|
71 | ;
|
---|
72 | ;Check .01 of CRV
|
---|
73 | I DDUCORD="" D
|
---|
74 | . D WMS("ORDER NUMBER of Cross-Reference Value #"_DDUCRV_" of "_DDUCIXID)
|
---|
75 | . D:DDUCFIX FON
|
---|
76 | S DDUCOID=$$OID(DDUCORD,"","",DDUCIXID)
|
---|
77 | ;
|
---|
78 | ;Make sure FILE is not null
|
---|
79 | I 'DDUCFIL D
|
---|
80 | . D WMS("FILE for "_DDUCOID,1)
|
---|
81 | ;
|
---|
82 | ;If there's a File, make sure it is equal to Root File
|
---|
83 | ;and that referenced field exists.
|
---|
84 | E D
|
---|
85 | . D:DDUCFIL'=DDUCRF WNE
|
---|
86 | . D:$D(^DD(DDUCFIL,DDUCFLD,0))[0 WFMS
|
---|
87 | . I $D(^DD("IX","F",DDUCFIL,DDUCFLD,DDUCIX,DDUCRV))[0 S DDUCGL=$NA(^(DDUCRV)) D
|
---|
88 | .. D WMS(DDUCGL)
|
---|
89 | .. D:DDUCFIX SET(DDUCGL)
|
---|
90 | Q
|
---|
91 | ;
|
---|
92 | CHKAC ;Check "AC index (In: DDUCFI = file; DDUCFIX = flag to fix)
|
---|
93 | N DDUCGL,DDUCIX
|
---|
94 | S DDUCIX=0 F S DDUCIX=$O(^DD("IX","AC",DDUCFI,DDUCIX)) Q:'DDUCIX D
|
---|
95 | . I $P($G(^DD("IX",DDUCIX,0)),U,9)]"",$P(^(0),U,9)'=DDUCFI D
|
---|
96 | .. S DDUCGL=$NA(^DD("IX","AC",DDUCFI,DDUCIX))
|
---|
97 | .. D WEN(DDUCGL)
|
---|
98 | .. D:DDUCFIX KILL(DDUCGL)
|
---|
99 | Q
|
---|
100 | ;
|
---|
101 | CHKBB ;Check "BB" index (In: DDUCFI = file; DDUCFIX = flag to fix)
|
---|
102 | N DDUCGL,DDUCIX,DDUCIX0,DDUCIXID,DDUCNM,DDUCNML
|
---|
103 | S DDUCNM=""
|
---|
104 | F S DDUCNM=$O(^DD("IX","BB",DDUCFI,DDUCNM)) Q:DDUCNM="" D
|
---|
105 | . S DDUCIX=0
|
---|
106 | . F DDUCIX=$O(^DD("IX","BB",DDUCFI,DDUCNM,DDUCIX)) Q:'DDUCIX D
|
---|
107 | .. S DDUCIX0=$G(^DD("IX",DDUCIX,0))
|
---|
108 | .. I $D(^DD("IX",DDUCIX)),$P(DDUCIX0,U,2)="" S DDUCNML(DDUCIX,DDUCNM)=""
|
---|
109 | .. E I $P(DDUCIX0,U)'=DDUCFI!($P(DDUCIX0,U,2)'=DDUCNM) D
|
---|
110 | ... S DDUCGL=$NA(^DD("IX","BB",DDUCFI,DDUCNM,DDUCIX))
|
---|
111 | ... D WEN(DDUCGL)
|
---|
112 | ... D:DDUCFIX KILL(DDUCGL)
|
---|
113 | ;
|
---|
114 | ;If any of the Indexes have null Names, check whether a single name
|
---|
115 | ;for it was found in the "BB" index.
|
---|
116 | I $D(DDUCNML) S DDUCIX=0 F S DDUCIX=$O(DDUCNML(DDUCIX)) Q:'DDUCIX D
|
---|
117 | . S DDUCNM=$O(DDUCNML(DDUCIX,""))
|
---|
118 | . I $O(DDUCNML(DDUCIX,DDUCNM))="" D
|
---|
119 | .. S DDUCIXID=$$IXID(DDUCIX,"")
|
---|
120 | .. D WNM
|
---|
121 | .. D:DDUCFIX FNM
|
---|
122 | . E F D S DDUCNM=$O(DDUCNML(DDUCIX,DDUCNM)) Q:DDUCNM=""
|
---|
123 | .. S DDUCGL=$NA(^DD("IX","BB",DDUCFI,DDUCNM,DDUCIX))
|
---|
124 | .. D WEN(DDUCGL)
|
---|
125 | .. D:DDUCFIX KILL(DDUCGL)
|
---|
126 | Q
|
---|
127 | ;
|
---|
128 | CHKF ;Check "F" index (In: DDUCFI = file; DDUCFIX = flag to fix)
|
---|
129 | N DDUCFLD,DDUCGL,DDUCIX,DDUCRV
|
---|
130 | S DDUCFLD=0
|
---|
131 | F S DDUCFLD=$O(^DD("IX","F",DDUCFI,DDUCFLD)) Q:'DDUCFLD D
|
---|
132 | . S DDUCIX=0
|
---|
133 | . F S DDUCIX=$O(^DD("IX","F",DDUCFI,DDUCFLD,DDUCIX)) Q:'DDUCIX D
|
---|
134 | .. S DDUCRV=0
|
---|
135 | .. F S DDUCRV=$O(^DD("IX","F",DDUCFI,DDUCFLD,DDUCIX,DDUCRV)) Q:'DDUCRV D
|
---|
136 | ... I $P($G(^DD("IX",DDUCIX,11.1,DDUCRV,0)),U,3)'=DDUCFI!($P($G(^(0)),U,4)'=DDUCFLD) D
|
---|
137 | .... S DDUCGL=$NA(^DD("IX","F",DDUCFI,DDUCFLD,DDUCIX,DDUCRV))
|
---|
138 | .... D WEN(DDUCGL)
|
---|
139 | .... D:DDUCFIX KILL(DDUCGL)
|
---|
140 | Q
|
---|
141 | ;
|
---|
142 | ;---------------
|
---|
143 | FFILE ;Set the .01 of index to DDUCFI
|
---|
144 | S $P(^DD("IX",DDUCIX,0),U)=DDUCFI
|
---|
145 | D WRITE("FILE (#.01) for "_DDUCIXID_" set to "_DDUCFI_".",10)
|
---|
146 | Q
|
---|
147 | ;
|
---|
148 | FRF ;Set Root File equal to File and Root Type to 'INDEX FILE'
|
---|
149 | S $P(^DD("IX",DDUCIX,0),U,8)="I"
|
---|
150 | S $P(^DD("IX",DDUCIX,0),U,9)=DDUCFI
|
---|
151 | S DDUCRF=DDUCFI
|
---|
152 | D WRITE("ROOT FILE for "_DDUCIXID_" set to "_DDUCFI_".",10)
|
---|
153 | D WRITE("ROOT TYPE for "_DDUCIXID_" set to 'INDEX FILE'.",10)
|
---|
154 | Q
|
---|
155 | ;
|
---|
156 | FON ;Determine Order Number
|
---|
157 | N DDUCI,DDUCO
|
---|
158 | ;
|
---|
159 | ;Look for Order Number in "B" index
|
---|
160 | S DDUCORD=0
|
---|
161 | F S DDUCORD=$O(^DD("IX",DDUCIX,11.1,"B",DDUCORD)) Q:'DDUCORD Q:$O(^DD("IX",DDUCIX,11.1,"B",DDUCORD,0))=DDUCRV
|
---|
162 | ;
|
---|
163 | ;If not found, just pick an unused Order Number
|
---|
164 | I 'DDUCORD D
|
---|
165 | . S DDUCI=0
|
---|
166 | . F S DDUCI=$O(^DD("IX",DDUCIX,11.1,DDUCI)) Q:'DDUCI S:$P($G(^(DDUCI,0)),U)]"" DDUCO($P(^(0),U))=""
|
---|
167 | . S DDUCORD=$O(DDUCO(""),-1)
|
---|
168 | . S:'DDUCORD DDUCORD=1
|
---|
169 | ;
|
---|
170 | S $P(^DD("IX",DDUCIX,11.1,DDUCRV,0),U)=DDUCORD
|
---|
171 | D WRITE("ORDER NUMBER for Cross-Reference Value #"_DDUCRV_" of "_DDUCIXID_" set to "_DDUCORD_".",10)
|
---|
172 | Q
|
---|
173 | ;
|
---|
174 | FNM ;Set the NAME for the Index
|
---|
175 | S $P(^DD("IX",DDUCIX,0),U,2)=DDUCNM
|
---|
176 | D WRITE("NAME for "_DDUCIXID_" set to '"_DDUCNM_"'.",10)
|
---|
177 | Q
|
---|
178 | ;
|
---|
179 | KILL(GL) ;Kill a global and print a message
|
---|
180 | Q:'$D(@GL)
|
---|
181 | K @GL
|
---|
182 | W !?10,GL_" was killed."
|
---|
183 | Q
|
---|
184 | ;
|
---|
185 | SET(GL,VAL) ;Set a global and print a message
|
---|
186 | Q:$D(@GL)
|
---|
187 | S VAL=$G(VAL),@GL=VAL
|
---|
188 | W !?10,GL_" was set"_$S(VAL]"":" to "_VAL,1:"")_"."
|
---|
189 | Q
|
---|
190 | ;
|
---|
191 | ;Write messages
|
---|
192 | WCHK Q ;D WRITE("Checking Indexes.",5) Q
|
---|
193 | WNOIX D WRITE(DDUCIXID_" does not exist.",7) Q
|
---|
194 | WMS(S,N) D WRITE("*"_S_" is missing."_$S($G(N):" ",1:""),7) Q
|
---|
195 | WNE D WRITE("*FILE does not equal ROOT FILE in "_DDUCOID_".",7) Q ;22*130
|
---|
196 | WFMS D WRITE("*File/Sub-file #"_$S($G(FIL)'="":FIL,1:DDUCFIL)_", Field #"_$S($G(FLD)'="":FLD,1:DDUCFLD)_" referenced in "_DDUCOID_" is missing.",7) Q ;22*130
|
---|
197 | WEN(GL) D WRITE("Erroneous node "_GL_" is set.",7) Q
|
---|
198 | WNM D WRITE("NAME for "_DDUCIXID_" looks like it should be '"_DDUCNM_"'.",7) Q
|
---|
199 | ;
|
---|
200 | WRITE(TXT,TAB) ;Write text, wrap at word boundaries.
|
---|
201 | N I
|
---|
202 | D WRAP^DIKCU2(.TXT,-TAB-2,-TAB)
|
---|
203 | W !?TAB,$G(TXT,$G(TXT(0))) F I=1:1 Q:'$D(TXT(I)) W !?TAB+2,TXT(I)
|
---|
204 | Q
|
---|
205 | ;
|
---|
206 | IXID(IX,NM) ;Return string that identifies an Index
|
---|
207 | S:'$D(NM) NM=$P($G(^DD("IX",IX,0)),U,2)
|
---|
208 | Q $S(NM]"":"'"_NM_"' Index (#"_IX_")",1:"Index #"_IX)
|
---|
209 | ;
|
---|
210 | OID(ORD,IX,NM,IXID) ;Return string that identifies Cross-Reference Value
|
---|
211 | I '$D(IXID),$G(IX) S IXID=$S($D(NM)#2:$$IXID(IX,NM),1:$$IXID(IX))
|
---|
212 | Q "Order #"_ORD_" of "_$S($G(IXID)]"":IXID,1:"")
|
---|