source: FOIAVistA/tag/r/VA_FILEMAN-ARJT-DI-DD-DM-DT-%DT-%RCR/DINIT2B8.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: 4.4 KB
Line 
1DINIT2B8 ;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 ^DINIT2B9
6Q Q
7 ;;^DIC(1.5216,0,"GL")
8 ;;=^DMSQ("E",
9 ;;^DIC("B","SQLI_TABLE_ELEMENT",1.5216)
10 ;;=
11 ;;^DIC(1.5216,"%D",0)
12 ;;=^^5^5^2970806^^^
13 ;;^DIC(1.5216,"%D",1,0)
14 ;;=Names and domains of primary keys, columns and foreign keys.
15 ;;^DIC(1.5216,"%D",2,0)
16 ;;=Each represents the relational concept of an attribute, whose essential
17 ;;^DIC(1.5216,"%D",3,0)
18 ;;=charactaristics are a name (unique by relation) and a domain.
19 ;;^DIC(1.5216,"%D",4,0)
20 ;;=
21 ;;^DIC(1.5216,"%D",5,0)
22 ;;=See SQLI_PRIMARY_KEY, SQLI_COLUMN and SQLI_FOREIGN key for more.
23 ;;^DD(1.5216,0)
24 ;;=FIELD^^4^5
25 ;;^DD(1.5216,0,"DDA")
26 ;;=N
27 ;;^DD(1.5216,0,"DT")
28 ;;=2960820
29 ;;^DD(1.5216,0,"IX","B",1.5216,.01)
30 ;;=
31 ;;^DD(1.5216,0,"IX","C",1.5216,1)
32 ;;=
33 ;;^DD(1.5216,0,"IX","D",1.5216,2)
34 ;;=
35 ;;^DD(1.5216,0,"IX","E",1.5216,3)
36 ;;=
37 ;;^DD(1.5216,0,"IX","F",1.5216,3)
38 ;;=
39 ;;^DD(1.5216,0,"IX","G",1.5216,2)
40 ;;=
41 ;;^DD(1.5216,0,"NM","SQLI_TABLE_ELEMENT")
42 ;;=
43 ;;^DD(1.5216,0,"PT",1.5217,.01)
44 ;;=
45 ;;^DD(1.5216,0,"PT",1.5218,.01)
46 ;;=
47 ;;^DD(1.5216,0,"PT",1.5219,.01)
48 ;;=
49 ;;^DD(1.5216,0,"VRPK")
50 ;;=DI
51 ;;^DD(1.5216,.01,0)
52 ;;=E_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
53 ;;^DD(1.5216,.01,.1)
54 ;;=Table Element
55 ;;^DD(1.5216,.01,1,0)
56 ;;=^.1
57 ;;^DD(1.5216,.01,1,1,0)
58 ;;=1.5216^B
59 ;;^DD(1.5216,.01,1,1,1)
60 ;;=S ^DMSQ("E","B",$E(X,1,30),DA)=""
61 ;;^DD(1.5216,.01,1,1,2)
62 ;;=K ^DMSQ("E","B",$E(X,1,30),DA)
63 ;;^DD(1.5216,.01,3)
64 ;;=Answer must be 3-30 characters in length.
65 ;;^DD(1.5216,.01,9)
66 ;;=^
67 ;;^DD(1.5216,.01,21,0)
68 ;;=^^2^2^2960926^
69 ;;^DD(1.5216,.01,21,1,0)
70 ;;=Name of table element.
71 ;;^DD(1.5216,.01,21,2,0)
72 ;;=Foreign keys are suffixed _FK or PFK. Primary keys are suffixed _PK.
73 ;;^DD(1.5216,.01,"DT")
74 ;;=2960820
75 ;;^DD(1.5216,1,0)
76 ;;=E_DOMAIN^RP1.5212'^DMSQ("DM",^0;2^Q
77 ;;^DD(1.5216,1,.1)
78 ;;=Domain
79 ;;^DD(1.5216,1,1,0)
80 ;;=^.1
81 ;;^DD(1.5216,1,1,1,0)
82 ;;=1.5216^C
83 ;;^DD(1.5216,1,1,1,1)
84 ;;=S ^DMSQ("E","C",$E(X,1,30),DA)=""
85 ;;^DD(1.5216,1,1,1,2)
86 ;;=K ^DMSQ("E","C",$E(X,1,30),DA)
87 ;;^DD(1.5216,1,1,1,"DT")
88 ;;=2960823
89 ;;^DD(1.5216,1,9)
90 ;;=^
91 ;;^DD(1.5216,1,21,0)
92 ;;=^^1^1^2960926^
93 ;;^DD(1.5216,1,21,1,0)
94 ;;=IEN of domain in SQLI_DOMAIN
95 ;;^DD(1.5216,1,"DT")
96 ;;=2960926
97 ;;^DD(1.5216,2,0)
98 ;;=E_TABLE^RP1.5215'^DMSQ("T",^0;3^Q
99 ;;^DD(1.5216,2,.1)
100 ;;=Table
101 ;;^DD(1.5216,2,1,0)
102 ;;=^.1
103 ;;^DD(1.5216,2,1,1,0)
104 ;;=1.5216^D
105 ;;^DD(1.5216,2,1,1,1)
106 ;;=S ^DMSQ("E","D",$E(X,1,30),DA)=""
107 ;;^DD(1.5216,2,1,1,2)
108 ;;=K ^DMSQ("E","D",$E(X,1,30),DA)
109 ;;^DD(1.5216,2,1,1,"DT")
110 ;;=2960823
111 ;;^DD(1.5216,2,1,2,0)
112 ;;=1.5216^G^MUMPS
113 ;;^DD(1.5216,2,1,2,1)
114 ;;=S ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)=""
115 ;;^DD(1.5216,2,1,2,2)
116 ;;=K ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)
117 ;;^DD(1.5216,2,1,2,"%D",0)
118 ;;=^^1^1^2960903^
119 ;;^DD(1.5216,2,1,2,"%D",1,0)
120 ;;=Table element by table by name
121 ;;^DD(1.5216,2,1,2,"DT")
122 ;;=2960903
123 ;;^DD(1.5216,2,9)
124 ;;=^
125 ;;^DD(1.5216,2,21,0)
126 ;;=^^1^1^2960926^
127 ;;^DD(1.5216,2,21,1,0)
128 ;;=IEN of table in SQLI_TABLE. Required.
129 ;;^DD(1.5216,2,"DT")
130 ;;=2960926
131 ;;^DD(1.5216,3,0)
132 ;;=E_TYPE^RS^C:Column;P:Primary key;F:Foreign key;^0;4^Q
133 ;;^DD(1.5216,3,.1)
134 ;;=Type
135 ;;^DD(1.5216,3,1,0)
136 ;;=^.1
137 ;;^DD(1.5216,3,1,1,0)
138 ;;=1.5216^E
139 ;;^DD(1.5216,3,1,1,1)
140 ;;=S ^DMSQ("E","E",$E(X,1,30),DA)=""
141 ;;^DD(1.5216,3,1,1,2)
142 ;;=K ^DMSQ("E","E",$E(X,1,30),DA)
143 ;;^DD(1.5216,3,1,1,"DT")
144 ;;=2960823
145 ;;^DD(1.5216,3,1,2,0)
146 ;;=1.5216^F^MUMPS
147 ;;^DD(1.5216,3,1,2,1)
148 ;;=S ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)=""
149 ;;^DD(1.5216,3,1,2,2)
150 ;;=K ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)
151 ;;^DD(1.5216,3,1,2,"%D",0)
152 ;;=^^1^1^2960827^^^^
153 ;;^DD(1.5216,3,1,2,"%D",1,0)
154 ;;=Table element by table by type
155 ;;^DD(1.5216,3,1,2,"DT")
156 ;;=2960827
157 ;;^DD(1.5216,3,9)
158 ;;=^
159 ;;^DD(1.5216,3,21,0)
160 ;;=^^1^1^2960926^
161 ;;^DD(1.5216,3,21,1,0)
162 ;;=C for column, P for primary key, or F for foreign key
163 ;;^DD(1.5216,3,"DT")
164 ;;=2960926
165 ;;^DD(1.5216,4,0)
166 ;;=E_COMMENT^F^^0;5^K:$L(X)>60!($L(X)<3) X
167 ;;^DD(1.5216,4,.1)
168 ;;=Comment
169 ;;^DD(1.5216,4,3)
170 ;;=Answer must be 3-60 characters in length.
171 ;;^DD(1.5216,4,9)
172 ;;=^
173 ;;^DD(1.5216,4,21,0)
174 ;;=^^1^1^2960926^
175 ;;^DD(1.5216,4,21,1,0)
176 ;;=A short description of the element
177 ;;^DD(1.5216,4,"DT")
178 ;;=2960926
Note: See TracBrowser for help on using the repository browser.