source: FOIAVistA/tag/r/VA_FILEMAN-ARJT-DI-DD-DM-DT-%DT-%RCR/DINIT2B9.m@ 636

Last change on this file since 636 was 628, checked in by George Lilly, 14 years ago

initial load of FOIAVistA 6/30/08 version
File size: 6.7 KB
Line 
1DINIT2B9 ;SFISC/MKO-SQLI FILES ;10:51 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(Q+I) Q:X="" S Y=$E($T(Q+I+1),4,999),X=$E(X,4,999) S:$A(Y)=126 I=I+1,Y=$E(Y,2,999)_$E($T(Q+I+1),5,99) S:$A(Y)=61 Y=$E(Y,2,999) S @X=Y
5 G ^DINIT2BA
6Q Q
7 ;;^DIC(1.5217,0,"GL")
8 ;;=^DMSQ("C",
9 ;;^DIC("B","SQLI_COLUMN",1.5217)
10 ;;=
11 ;;^DIC(1.5217,"%D",0)
12 ;;=^^6^6^2970806^^
13 ;;^DIC(1.5217,"%D",1,0)
14 ;;=A set of formatting and physical structure specifications.
15 ;;^DIC(1.5217,"%D",2,0)
16 ;;=Each column specification has a column type table element
17 ;;^DIC(1.5217,"%D",3,0)
18 ;;=(SQLI_TABLE_ELEMENT) which contains the relational specifications, name
19 ;;^DIC(1.5217,"%D",4,0)
20 ;;=and domain. The column specification contains those attributes required
21 ;;^DIC(1.5217,"%D",5,0)
22 ;;=to locate the value in the global structure, and to project the value to
23 ;;^DIC(1.5217,"%D",6,0)
24 ;;=the user.
25 ;;^DD(1.5217,0)
26 ;;=FIELD^^16^17
27 ;;^DD(1.5217,0,"DT")
28 ;;=2970311
29 ;;^DD(1.5217,0,"IX","B",1.5217,.01)
30 ;;=
31 ;;^DD(1.5217,0,"IX","C",1.5217,8)
32 ;;=
33 ;;^DD(1.5217,0,"IX","D",1.5217,4)
34 ;;=
35 ;;^DD(1.5217,0,"IX","E",1.5217,16)
36 ;;=
37 ;;^DD(1.5217,0,"NM","SQLI_COLUMN")
38 ;;=
39 ;;^DD(1.5217,0,"PT",1.5217,8)
40 ;;=
41 ;;^DD(1.5217,0,"PT",1.5218,1)
42 ;;=
43 ;;^DD(1.5217,0,"PT",1.5219,2)
44 ;;=
45 ;;^DD(1.5217,0,"VRPK")
46 ;;=DI
47 ;;^DD(1.5217,.01,0)
48 ;;=C_TABLE_ELEMENT^RP1.5216'^DMSQ("E",^0;1^Q
49 ;;^DD(1.5217,.01,.1)
50 ;;=Table Element
51 ;;^DD(1.5217,.01,1,0)
52 ;;=^.1
53 ;;^DD(1.5217,.01,1,1,0)
54 ;;=1.5217^B
55 ;;^DD(1.5217,.01,1,1,1)
56 ;;=S ^DMSQ("C","B",$E(X,1,30),DA)=""
57 ;;^DD(1.5217,.01,1,1,2)
58 ;;=K ^DMSQ("C","B",$E(X,1,30),DA)
59 ;;^DD(1.5217,.01,3)
60 ;;=
61 ;;^DD(1.5217,.01,9)
62 ;;=^
63 ;;^DD(1.5217,.01,21,0)
64 ;;=^^1^1^2960926^^
65 ;;^DD(1.5217,.01,21,1,0)
66 ;;=IEN of table element.
67 ;;^DD(1.5217,.01,"DT")
68 ;;=2960820
69 ;;^DD(1.5217,1,0)
70 ;;=C_FILE^NJ16,6^^0;5^K:+X'=X!(X>999999999.999999)!(X<1)!(X?.E1"."7N.N) X
71 ;;^DD(1.5217,1,.1)
72 ;;=File ID
73 ;;^DD(1.5217,1,3)
74 ;;=Type a Number between 1 and 999999999.999999, 6 Decimal Digits
75 ;;^DD(1.5217,1,9)
76 ;;=^
77 ;;^DD(1.5217,1,21,0)
78 ;;=^^2^2^2960926^
79 ;;^DD(1.5217,1,21,1,0)
80 ;;=FileMan file (or subfile) ID, if column was derived from ^DD.
81 ;;^DD(1.5217,1,21,2,0)
82 ;;= NULL if column is generated by SQLI.
83 ;;^DD(1.5217,1,"DT")
84 ;;=2960926
85 ;;^DD(1.5217,2,0)
86 ;;=C_WIDTH^NJ2,0^^0;2^K:+X'=X!(X>22)!(X<1)!(X?.E1"."1N.N) X
87 ;;^DD(1.5217,2,.1)
88 ;;=Width
89 ;;^DD(1.5217,2,3)
90 ;;=Type an integer between 1 and 999999999999999
91 ;;^DD(1.5217,2,9)
92 ;;=^
93 ;;^DD(1.5217,2,21,0)
94 ;;=^^3^3^2960926^
95 ;;^DD(1.5217,2,21,1,0)
96 ;;=Field width for display
97 ;;^DD(1.5217,2,21,2,0)
98 ;;=This field is estimated by SQLI from evidence in ^DD unless it's specified
99 ;;^DD(1.5217,2,21,3,0)
100 ;;=with J modifier.
101 ;;^DD(1.5217,2,"DT")
102 ;;=2960820
103 ;;^DD(1.5217,3,0)
104 ;;=C_SCALE^NJ1,0^^0;3^K:+X'=X!(X>9)!(X<1)!(X?.E1"."1N.N) X
105 ;;^DD(1.5217,3,.1)
106 ;;=Dec. Pt.
107 ;;^DD(1.5217,3,3)
108 ;;=Type a Number between 1 and 9, 0 Decimal Digits
109 ;;^DD(1.5217,3,9)
110 ;;=^
111 ;;^DD(1.5217,3,21,0)
112 ;;=^^2^2^2960926^
113 ;;^DD(1.5217,3,21,1,0)
114 ;;=Number of decimal points to display on output (numeric only).
115 ;;^DD(1.5217,3,21,2,0)
116 ;;=If scale is specified as 0, SQLI projects column as integer.
117 ;;^DD(1.5217,3,"DT")
118 ;;=2960926
119 ;;^DD(1.5217,4,0)
120 ;;=C_FIELD^NJ15,7^^0;6^K:+X'=X!(X>9999999.9999999)!(X<.001)!(X?.E1"."8N.N) X
121 ;;^DD(1.5217,4,1,0)
122 ;;=^.1
123 ;;^DD(1.5217,4,1,1,0)
124 ;;=1.5217^D^MUMPS
125 ;;^DD(1.5217,4,1,1,1)
126 ;;=S ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)=""
127 ;;^DD(1.5217,4,1,1,2)
128 ;;=K ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)
129 ;;^DD(1.5217,4,1,1,"%D",0)
130 ;;=^^1^1^2960827^
131 ;;^DD(1.5217,4,1,1,"%D",1,0)
132 ;;=Column by FileMan File number, by field number
133 ;;^DD(1.5217,4,1,1,"DT")
134 ;;=2960827
135 ;;^DD(1.5217,4,3)
136 ;;=Type a Number between .001 and 9999999.9999999, 7 Decimal Digits
137 ;;^DD(1.5217,4,9)
138 ;;=^
139 ;;^DD(1.5217,4,21,0)
140 ;;=^^2^2^2970311^^^
141 ;;^DD(1.5217,4,21,1,0)
142 ;;=FileMan field ID from ^DD
143 ;;^DD(1.5217,4,21,2,0)
144 ;;=NULL unless column is derived directly from the data dictionary.
145 ;;^DD(1.5217,4,"DT")
146 ;;=2970311
147 ;;^DD(1.5217,5,0)
148 ;;=C_NOT_NULL^S^0:Not required;1:Required;^0;7^Q
149 ;;^DD(1.5217,5,.1)
150 ;;=Req.
151 ;;^DD(1.5217,5,9)
152 ;;=^
153 ;;^DD(1.5217,5,21,0)
154 ;;=^^1^1^2960926^
155 ;;^DD(1.5217,5,21,1,0)
156 ;;=When true (1) value is required, when false (0) not required.
157 ;;^DD(1.5217,5,"DT")
158 ;;=2960926
159 ;;^DD(1.5217,6,0)
160 ;;=C_SECURE^S^0:Not secure;1:Secure;^0;8^Q
161 ;;^DD(1.5217,6,.1)
162 ;;=Secure
163 ;;^DD(1.5217,6,9)
164 ;;=^
165 ;;^DD(1.5217,6,21,0)
166 ;;=^^2^2^2960926^
167 ;;^DD(1.5217,6,21,1,0)
168 ;;=If true, there is a security screen, else not.
169 ;;^DD(1.5217,6,21,2,0)
170 ;;=When this flag is set, vendors should use DBS to retrieve data.
171 ;;^DD(1.5217,6,"DT")
172 ;;=2960926
173 ;;^DD(1.5217,7,0)
174 ;;=C_VIRTUAL^S^0:Base column;1:Calculated value column;^0;9^Q
175 ;;^DD(1.5217,7,.1)
176 ;;=Virtual
177 ;;^DD(1.5217,7,9)
178 ;;=^
179 ;;^DD(1.5217,7,21,0)
180 ;;=^^2^2^2960926^
181 ;;^DD(1.5217,7,21,1,0)
182 ;;=If true, the value is computed.
183 ;;^DD(1.5217,7,21,2,0)
184 ;;=Vendors should use DBS to get value.
185 ;;^DD(1.5217,7,"DT")
186 ;;=2960926
187 ;;^DD(1.5217,8,0)
188 ;;=C_PARENT^P1.5217'^DMSQ("C",^0;10^Q
189 ;;^DD(1.5217,8,.1)
190 ;;=Parent Column
191 ;;^DD(1.5217,8,1,0)
192 ;;=^.1
193 ;;^DD(1.5217,8,1,1,0)
194 ;;=1.5217^C
195 ;;^DD(1.5217,8,1,1,1)
196 ;;=S ^DMSQ("C","C",$E(X,1,30),DA)=""
197 ;;^DD(1.5217,8,1,1,2)
198 ;;=K ^DMSQ("C","C",$E(X,1,30),DA)
199 ;;^DD(1.5217,8,1,1,"%D",0)
200 ;;=^^1^1^2960823^
201 ;;^DD(1.5217,8,1,1,"%D",1,0)
202 ;;=Column by parent column
203 ;;^DD(1.5217,8,1,1,"DT")
204 ;;=2960823
205 ;;^DD(1.5217,8,9)
206 ;;=^
207 ;;^DD(1.5217,8,21,0)
208 ;;=^^2^2^2960926^
209 ;;^DD(1.5217,8,21,1,0)
210 ;;=Column whose physical global structure precedes this column.
211 ;;^DD(1.5217,8,21,2,0)
212 ;;=Used to construct global root. Chain goes back to ^DIC.
213 ;;^DD(1.5217,8,"DT")
214 ;;=2960926
215 ;;^DD(1.5217,9,0)
216 ;;=C_GLOBAL^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
217 ;;^DD(1.5217,9,.1)
218 ;;=Global
219 ;;^DD(1.5217,9,3)
220 ;;=M global fragment which precedes this element
221 ;;^DD(1.5217,9,9)
222 ;;=^
223 ;;^DD(1.5217,9,21,0)
224 ;;=^^3^3^2960926^
225 ;;^DD(1.5217,9,21,1,0)
226 ;;=M global fragment between this column and parent column.
227 ;;^DD(1.5217,9,21,2,0)
228 ;;=Contains node specifier for non-key columns. Key columns are constructed
229 ;;^DD(1.5217,9,21,3,0)
230 ;;=by SQLI and contain the multiple node specifier or ^DIC root.
231 ;;^DD(1.5217,9,"DT")
232 ;;=2960926
233 ;;^DD(1.5217,10,0)
234 ;;=C_PIECE^NJ2,0^^0;11^K:+X'=X!(X>99)!(X<1)!(X?.E1"."1N.N) X
235 ;;^DD(1.5217,10,.1)
236 ;;=Piece
237 ;;^DD(1.5217,10,3)
238 ;;=Type a Number between 1 and 99, 0 Decimal Digits
239 ;;^DD(1.5217,10,9)
240 ;;=^
241 ;;^DD(1.5217,10,21,0)
242 ;;=^^2^2^2960926^
243 ;;^DD(1.5217,10,21,1,0)
244 ;;=The piece address of the column in a data string.
245 ;;^DD(1.5217,10,21,2,0)
246 ;;=If the piece address was of form E1,30, this value is null.
247 ;;^DD(1.5217,10,"DT")
248 ;;=2960926
249 ;;^DD(1.5217,11,0)
250 ;;=C_EXTRACT_FROM^NJ3,0^^0;12^K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X
Note: See TracBrowser for help on using the repository browser.