1 | DDUCHK5 ;SFISC/MKO-CHECK KEYS ON FILE ;8/8/03 06:26
|
---|
2 | ;;22.0;VA FileMan;*130*;Mar 30, 1999
|
---|
3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
---|
4 | ;
|
---|
5 | KEY(DDUCFI,DDUCFIX) ;Check and optionally fix structure of Key file entry
|
---|
6 | N DDUCKEY
|
---|
7 | Q:'$G(DDUCFI) S DDUCFIX=$G(DDUCFIX)
|
---|
8 | ;
|
---|
9 | ;Loop through "B" index to find KEYs that reside on this file
|
---|
10 | D WCHK
|
---|
11 | S DDUCKEY=""
|
---|
12 | F S DDUCKEY=$O(^DD("KEY","B",DDUCFI,DDUCKEY)) Q:DDUCKEY="" D CHKKEY
|
---|
13 | ;
|
---|
14 | ;Check "AP","BB", and "F" indexes
|
---|
15 | D CHKAP,CHKBB,CHKF
|
---|
16 | Q
|
---|
17 | ;
|
---|
18 | CHKKEY ;Check Key DDUCKEY found in "B" index
|
---|
19 | ;In:
|
---|
20 | ; DDUCKEY = Key #
|
---|
21 | ; DDUCFI = File #
|
---|
22 | ; DDUCFIX = Flag to fix
|
---|
23 | N DDUCIEN,DDUCKEY0,DDUCKID,DDUCNM,DDUCUI
|
---|
24 | S DDUCKID=$$KEYID(DDUCKEY,"")
|
---|
25 | ;
|
---|
26 | ;Check that Key exists
|
---|
27 | I '$D(^DD("KEY",DDUCKEY)) D Q
|
---|
28 | . D WNOKEY
|
---|
29 | . D:DDUCFIX KILL($NA(^DD("KEY","B",DDUCFI,DDUCKEY)))
|
---|
30 | ;
|
---|
31 | ;Check that Key has a FILE
|
---|
32 | S DDUCKEY0=$G(^DD("KEY",DDUCKEY,0))
|
---|
33 | I $P(DDUCKEY0,U)="" D
|
---|
34 | . D WMS("FILE (#.01) for "_DDUCKID)
|
---|
35 | . D:DDUCFIX FFILE
|
---|
36 | ;
|
---|
37 | ;Get Name
|
---|
38 | S DDUCNM=$P(DDUCKEY0,U,2)
|
---|
39 | I DDUCNM]"" S DDUCKID=$$KEYID(DDUCKEY,DDUCNM)
|
---|
40 | E D WMS("NAME for "_DDUCKID)
|
---|
41 | ;
|
---|
42 | ;Check Priority
|
---|
43 | S DDUCPRI=$P(DDUCKEY0,U,3)
|
---|
44 | D:DDUCPRI="" WMS("PRIORITY for "_DDUCKID)
|
---|
45 | ;
|
---|
46 | ;Check Uniqueness Index
|
---|
47 | S DDUCUI=$P(DDUCKEY0,U,4)
|
---|
48 | I 'DDUCUI D
|
---|
49 | . D WMS("Uniqueness Index for "_DDUCKID,1)
|
---|
50 | E D
|
---|
51 | . I '$D(^DD("IX",DDUCUI,0)) D Q
|
---|
52 | .. D WMS("Dangling pointer. Uniqueness Index #"_DDUCUI_" pointed to by "_DDUCKID,1)
|
---|
53 | . D GETFLD^DIKKUTL2(DDUCKEY,DDUCUI,.DDUCKFLD,.DDUCUFLD)
|
---|
54 | . D:'$$GCMP^DIKCU2("DDUCKFLD","DDUCUFLD") WNE
|
---|
55 | ;
|
---|
56 | ;Check Field multiple
|
---|
57 | S DDUCIEN=0
|
---|
58 | F S DDUCIEN=$O(^DD("KEY",DDUCKEY,2,DDUCIEN)) Q:'DDUCIEN D FLD
|
---|
59 | ;
|
---|
60 | ;Reindex Key file entry
|
---|
61 | I DDUCFIX D
|
---|
62 | . N DIC,DIK,DA,X
|
---|
63 | . S DIK="^DD(""KEY"",",DA=DDUCKEY
|
---|
64 | . D IX^DIK
|
---|
65 | Q
|
---|
66 | ;
|
---|
67 | FLD ;Check a Cross-Reference Value
|
---|
68 | ;In:
|
---|
69 | ; DDUCKEY = Key #
|
---|
70 | ; DDUCIEN = IEN in FIELD multiple
|
---|
71 | ; DDUCFIX = Flag to fix
|
---|
72 | ; DDUCKID = String that identifies Key
|
---|
73 | ; DDUCUI = Uniqueness index #
|
---|
74 | N DDUCFIL,DDUCFLD,DDUCFLD0,DDUCKFLD,DDUCSEQ,DDUCUFLD
|
---|
75 | ;
|
---|
76 | S DDUCFLD0=$G(^DD("KEY",DDUCKEY,2,DDUCIEN,0))
|
---|
77 | S DDUCFLD=$P(DDUCFLD0,U),DDUCFIL=$P(DDUCFLD0,U,2)
|
---|
78 | S DDUCSEQ=$P(DDUCFLD0,U,3)
|
---|
79 | ;
|
---|
80 | ;Check that field, file, and sequence are filled in
|
---|
81 | D:'DDUCFLD!'DDUCFIL!'DDUCSEQ WINC
|
---|
82 | ;
|
---|
83 | ;Make sure file/field exists and is in the "F" index
|
---|
84 | I DDUCFLD,DDUCFIL D
|
---|
85 | . D:$D(^DD(DDUCFIL,DDUCFLD,0))[0 WFMS
|
---|
86 | . I $D(^DD("KEY","F",DDUCFIL,DDUCFLD,DDUCKEY,DDUCIEN))[0 S DDUCGL=$NA(^(DDUCIEN)) D
|
---|
87 | .. D WMS(DDUCGL)
|
---|
88 | .. D:DDUCFIX SET(DDUCGL)
|
---|
89 | Q
|
---|
90 | ;
|
---|
91 | CHKAP ;Check "AP" index (In: DDUCFI = file; DDUCFIX = flag to fix)
|
---|
92 | N DDUCGL,DDUCKEY,DDUCKEY0,DDUCPRI,DDUCPRIL
|
---|
93 | ;
|
---|
94 | S DDUCPRI=""
|
---|
95 | F S DDUCPRI=$O(^DD("KEY","AP",DDUCFI,DDUCPRI)) Q:DDUCPRI="" D
|
---|
96 | . S DDUCKEY=0
|
---|
97 | . F S DDUCKEY=$O(^DD("KEY","AP",DDUCFI,DDUCPRI,DDUCKEY)) Q:'DDUCKEY D
|
---|
98 | .. S DDUCKEY0=$G(^DD("KEY",DDUCKEY,0))
|
---|
99 | .. I $D(^DD("KEY",DDUCKEY)),$P(DDUCKEY0,U,3)="" S DDUCPRIL(DDUCKEY,DDUCPRI)=""
|
---|
100 | .. E I $P(DDUCKEY0,U)'=DDUCFI!($P(DDUCKEY0,U,3)'=DDUCPRI) D
|
---|
101 | ... S DDUCGL=$NA(^DD("KEY","AP",DDUCFI,DDUCPRI,DDUCKEY))
|
---|
102 | ... D WEN(DDUCGL)
|
---|
103 | ... D:DDUCFIX KILL(DDUCGL)
|
---|
104 | ;
|
---|
105 | ;If any of the Keys have null Priorities, check whether a single
|
---|
106 | ;priority for it was found in the "AP" index.
|
---|
107 | I $D(DDUCPRIL) S DDUCKEY=0 F S DDUCKEY=$O(DDUCPRIL(DDUCKEY)) Q:'DDUCKEY D
|
---|
108 | . S DDUCPRI=$O(DDUCPRIL(DDUCKEY,""))
|
---|
109 | . I $O(DDUCPRIL(DDUCKEY,DDUCPRI))="" D
|
---|
110 | .. S DDUCKID=$$KEYID(DDUCKEY)
|
---|
111 | .. D WPRI
|
---|
112 | .. D:DDUCFIX FPRI
|
---|
113 | . E F D S DDUCPRI=$O(DDUCPRIL(DDUCKEY,DDUCPRI)) Q:DDUCPRI=""
|
---|
114 | .. S DDUCGL=$NA(^DD("KEY","AP",DDUCFI,DDUCPRI,DDUCKEY))
|
---|
115 | .. D WEN(DDUCGL)
|
---|
116 | .. D:DDUCFIX KILL(DDUCGL)
|
---|
117 | Q
|
---|
118 | ;
|
---|
119 | CHKBB ;Check "BB" index (In: DDUCFI = file; DDUCFIX = flag to fix)
|
---|
120 | N DDUCGL,DDUCKEY,DDUCKEY0,DDUCKID,DDUCNM,DDUCNML
|
---|
121 | S DDUCNM=""
|
---|
122 | F S DDUCNM=$O(^DD("KEY","BB",DDUCFI,DDUCNM)) Q:DDUCNM="" D
|
---|
123 | . S DDUCKEY=0
|
---|
124 | . F DDUCKEY=$O(^DD("KEY","BB",DDUCFI,DDUCNM,DDUCKEY)) Q:'DDUCKEY D
|
---|
125 | .. S DDUCKEY0=$G(^DD("KEY",DDUCKEY,0))
|
---|
126 | .. I $D(^DD("KEY",DDUCKEY)),$P(DDUCKEY0,U,2)="" S DDUCNML(DDUCKEY,DDUCNM)=""
|
---|
127 | .. E I $P(DDUCKEY0,U)'=DDUCFI!($P(DDUCKEY0,U,2)'=DDUCNM) D
|
---|
128 | ... S DDUCGL=$NA(^DD("KEY","BB",DDUCFI,DDUCNM,DDUCKEY))
|
---|
129 | ... D WEN(DDUCGL)
|
---|
130 | ... D:DDUCFIX KILL(DDUCGL)
|
---|
131 | ;
|
---|
132 | ;If any of the Keys have null Names, check whether a single name
|
---|
133 | ;for it was found in the "BB" index.
|
---|
134 | I $D(DDUCNML) S DDUCKEY=0 F S DDUCKEY=$O(DDUCNML(DDUCKEY)) Q:'DDUCKEY D
|
---|
135 | . S DDUCNM=$O(DDUCNML(DDUCKEY,""))
|
---|
136 | . I $O(DDUCNML(DDUCKEY,DDUCNM))="" D
|
---|
137 | .. S DDUCKID=$$KEYID(DDUCKEY,"")
|
---|
138 | .. D WNM
|
---|
139 | .. D:DDUCFIX FNM
|
---|
140 | . E F D S DDUCNM=$O(DDUCNML(DDUCKEY,DDUCNM)) Q:DDUCNM=""
|
---|
141 | .. S DDUCGL=$NA(^DD("KEY","BB",DDUCFI,DDUCNM,DDUCKEY))
|
---|
142 | .. D WEN(DDUCGL)
|
---|
143 | .. D:DDUCFIX KILL(DDUCGL)
|
---|
144 | Q
|
---|
145 | ;
|
---|
146 | CHKF ;Check "F" index (In: DDUCFI = file; DDUCFIX = flag to fix)
|
---|
147 | N DDUCFLD,DDUCGL,DDUCKEY,DDUCIEN
|
---|
148 | S DDUCFLD=0
|
---|
149 | F S DDUCFLD=$O(^DD("KEY","F",DDUCFI,DDUCFLD)) Q:'DDUCFLD D
|
---|
150 | . S DDUCKEY=0
|
---|
151 | . F S DDUCKEY=$O(^DD("KEY","F",DDUCFI,DDUCFLD,DDUCKEY)) Q:'DDUCKEY D
|
---|
152 | .. S DDUCIEN=0
|
---|
153 | .. F S DDUCIEN=$O(^DD("KEY","F",DDUCFI,DDUCFLD,DDUCKEY,DDUCIEN)) Q:'DDUCIEN D
|
---|
154 | ... I $P($G(^DD("KEY",DDUCKEY,2,DDUCIEN,0)),U,2)'=DDUCFI!($P($G(^(0)),U)'=DDUCFLD) D
|
---|
155 | .... S DDUCGL=$NA(^DD("KEY","F",DDUCFI,DDUCFLD,DDUCKEY,DDUCIEN))
|
---|
156 | .... D WEN(DDUCGL)
|
---|
157 | .... D:DDUCFIX KILL(DDUCGL)
|
---|
158 | Q
|
---|
159 | ;
|
---|
160 | ;---------------
|
---|
161 | FFILE ;Set the .01 of Key to DDUCFI
|
---|
162 | S $P(^DD("KEY",DDUCKEY,0),U)=DDUCFI
|
---|
163 | D WRITE("FILE (#.01) for "_DDUCKID_" set to "_DDUCFI_".",10)
|
---|
164 | Q
|
---|
165 | ;
|
---|
166 | FNM ;Set the NAME for the Key
|
---|
167 | S $P(^DD("KEY",DDUCKEY,0),U,2)=DDUCNM
|
---|
168 | D WRITE("NAME for "_DDUCKID_" set to '"_DDUCNM_"'.",10)
|
---|
169 | Q
|
---|
170 | ;
|
---|
171 | FPRI ;Set the PRIORITY for the Key
|
---|
172 | S $P(^DD("KEY",DDUCKEY,0),U,3)=DDUCPRI
|
---|
173 | D WRITE("PRIORITY for "_DDUCKID_" set to '"_DDUCPRI_"'.",10)
|
---|
174 | Q
|
---|
175 | ;
|
---|
176 | KILL(GL) ;Kill a global and print a message
|
---|
177 | Q:'$D(@GL)
|
---|
178 | K @GL
|
---|
179 | W !?10,GL_" was killed."
|
---|
180 | Q
|
---|
181 | ;
|
---|
182 | SET(GL,VAL) ;Set a global and print a message
|
---|
183 | Q:$D(@GL)
|
---|
184 | S VAL=$G(VAL),@GL=VAL
|
---|
185 | W !?10,GL_" was set"_$S(VAL]"":" to "_VAL,1:"")_"."
|
---|
186 | Q
|
---|
187 | ;
|
---|
188 | ;Write messages
|
---|
189 | WCHK Q ;D WRITE("Checking Keys.",5) Q
|
---|
190 | WNOKEY D WRITE(DDUCKID_" does not exist.",7) Q
|
---|
191 | WMS(S,N) D WRITE(S_" is missing."_$S($G(N):" Nothing done.",1:""),7) Q
|
---|
192 | WINC D WRITE("Field information in "_DDUCKEY_" is incomplete. Nothing done.",7) Q
|
---|
193 | WFMS D WRITE("*File #"_DDUCFIL_", Field #"_DDUCFLD_" referenced in "_DDUCKEY_" is missing.",7) Q ;22*130
|
---|
194 | WNE D WRITE("*Fields in "_DDUCKID_" don't match fields in Uniqueness Index.",7) Q ;22*130
|
---|
195 | WEN(GL) D WRITE("Erroneous node "_GL_" is set.",7) Q
|
---|
196 | WNM D WRITE("NAME for "_DDUCKID_" looks like it should be '"_DDUCNM_"'.",7) Q
|
---|
197 | WPRI D WRITE("PRIORITY for "_DDUCKID_" looks like it should be '"_DDUCPRI_"'.",7) Q
|
---|
198 | ;
|
---|
199 | WRITE(TXT,TAB) ;Write text, wrap at word boundaries.
|
---|
200 | N I
|
---|
201 | D WRAP^DIKCU2(.TXT,-TAB-2,-TAB)
|
---|
202 | W !?TAB,$G(TXT,$G(TXT(0))) F I=1:1 Q:'$D(TXT(I)) W !?TAB+2,TXT(I)
|
---|
203 | Q
|
---|
204 | ;
|
---|
205 | KEYID(KEY,NM) ;Return string that identifies a Key
|
---|
206 | S:'$D(NM) NM=$P($G(^DD("KEY",KEY,0)),U,2)
|
---|
207 | Q $S(NM]"":"Key '"_NM_"' (#"_KEY_")",1:"Key #"_KEY)
|
---|