[613] | 1 | DINIT2B3 ;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 ^DINIT2B4
|
---|
| 6 | Q Q
|
---|
| 7 | ;;^DIC(1.5212,0,"GL")
|
---|
| 8 | ;;=^DMSQ("DM",
|
---|
| 9 | ;;^DIC("B","SQLI_DOMAIN",1.5212)
|
---|
| 10 | ;;=
|
---|
| 11 | ;;^DIC(1.5212,"%D",0)
|
---|
| 12 | ;;=^^11^11^2970806^^
|
---|
| 13 | ;;^DIC(1.5212,"%D",1,0)
|
---|
| 14 | ;;=The set from which all objects of that domain must be drawn.
|
---|
| 15 | ;;^DIC(1.5212,"%D",2,0)
|
---|
| 16 | ;;=In SQLI, all table elements (SQLI_TABLE_ELEMENT) have a domain which
|
---|
| 17 | ;;^DIC(1.5212,"%D",3,0)
|
---|
| 18 | ;;=restricts them to their domain set. For each data type there is a domain
|
---|
| 19 | ;;^DIC(1.5212,"%D",4,0)
|
---|
| 20 | ;;=of the same name, representing the same set. Other domains have different
|
---|
| 21 | ;;^DIC(1.5212,"%D",5,0)
|
---|
| 22 | ;;=set membership restrictions.
|
---|
| 23 | ;;^DIC(1.5212,"%D",6,0)
|
---|
| 24 | ;;=
|
---|
| 25 | ;;^DIC(1.5212,"%D",7,0)
|
---|
| 26 | ;;=Each domain has a data type, which determines the rules for comparing
|
---|
| 27 | ;;^DIC(1.5212,"%D",8,0)
|
---|
| 28 | ;;=values from different domains, and the operators which may be used on them.
|
---|
| 29 | ;;^DIC(1.5212,"%D",9,0)
|
---|
| 30 | ;;=
|
---|
| 31 | ;;^DIC(1.5212,"%D",10,0)
|
---|
| 32 | ;;=The PRIMARY_KEY data type and domain is unique to SQLI. It is used to
|
---|
| 33 | ;;^DIC(1.5212,"%D",11,0)
|
---|
| 34 | ;;=relate primary keys to foreign keys unambiguously (see SQLI_TABLE_ELEMENT)
|
---|
| 35 | ;;^DD(1.5212,0)
|
---|
| 36 | ;;=FIELD^^11^12
|
---|
| 37 | ;;^DD(1.5212,0,"DDA")
|
---|
| 38 | ;;=N
|
---|
| 39 | ;;^DD(1.5212,0,"DT")
|
---|
| 40 | ;;=2970225
|
---|
| 41 | ;;^DD(1.5212,0,"IX","B",1.5212,.01)
|
---|
| 42 | ;;=
|
---|
| 43 | ;;^DD(1.5212,0,"IX","C",1.5212,3)
|
---|
| 44 | ;;=
|
---|
| 45 | ;;^DD(1.5212,0,"IX","D",1.5212,11)
|
---|
| 46 | ;;=
|
---|
| 47 | ;;^DD(1.5212,0,"IX","E",1.5212,1)
|
---|
| 48 | ;;=
|
---|
| 49 | ;;^DD(1.5212,0,"NM","SQLI_DOMAIN")
|
---|
| 50 | ;;=
|
---|
| 51 | ;;^DD(1.5212,0,"PT",1.5216,1)
|
---|
| 52 | ;;=
|
---|
| 53 | ;;^DD(1.5212,0,"VRPK")
|
---|
| 54 | ;;=DI
|
---|
| 55 | ;;^DD(1.5212,.01,0)
|
---|
| 56 | ;;=DM_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
|
---|
| 57 | ;;^DD(1.5212,.01,.1)
|
---|
| 58 | ;;=Domain
|
---|
| 59 | ;;^DD(1.5212,.01,1,0)
|
---|
| 60 | ;;=^.1
|
---|
| 61 | ;;^DD(1.5212,.01,1,1,0)
|
---|
| 62 | ;;=1.5212^B
|
---|
| 63 | ;;^DD(1.5212,.01,1,1,1)
|
---|
| 64 | ;;=S ^DMSQ("DM","B",$E(X,1,30),DA)=""
|
---|
| 65 | ;;^DD(1.5212,.01,1,1,2)
|
---|
| 66 | ;;=K ^DMSQ("DM","B",$E(X,1,30),DA)
|
---|
| 67 | ;;^DD(1.5212,.01,3)
|
---|
| 68 | ;;=Answer must be an SQL identifier 3-30 characters in length.
|
---|
| 69 | ;;^DD(1.5212,.01,4)
|
---|
| 70 | ;;=W ?5,"Must be a valid SQL identifier"
|
---|
| 71 | ;;^DD(1.5212,.01,9)
|
---|
| 72 | ;;=^
|
---|
| 73 | ;;^DD(1.5212,.01,21,0)
|
---|
| 74 | ;;=^^2^2^2970311^^^^
|
---|
| 75 | ;;^DD(1.5212,.01,21,1,0)
|
---|
| 76 | ;;=Name of FileMan domain
|
---|
| 77 | ;;^DD(1.5212,.01,21,2,0)
|
---|
| 78 | ;;=Includes names of standard SQL data types. Must not be a keyword.
|
---|
| 79 | ;;^DD(1.5212,.01,"DT")
|
---|
| 80 | ;;=2960820
|
---|
| 81 | ;;^DD(1.5212,1,0)
|
---|
| 82 | ;;=DM_DATA_TYPE^RP1.5211'^DMSQ("DT",^0;2^Q
|
---|
| 83 | ;;^DD(1.5212,1,.1)
|
---|
| 84 | ;;=Data Type
|
---|
| 85 | ;;^DD(1.5212,1,1,0)
|
---|
| 86 | ;;=^.1
|
---|
| 87 | ;;^DD(1.5212,1,1,1,0)
|
---|
| 88 | ;;=1.5212^E
|
---|
| 89 | ;;^DD(1.5212,1,1,1,1)
|
---|
| 90 | ;;=S ^DMSQ("DM","E",$E(X,1,30),DA)=""
|
---|
| 91 | ;;^DD(1.5212,1,1,1,2)
|
---|
| 92 | ;;=K ^DMSQ("DM","E",$E(X,1,30),DA)
|
---|
| 93 | ;;^DD(1.5212,1,1,1,"%D",0)
|
---|
| 94 | ;;=^^1^1^2960909^
|
---|
| 95 | ;;^DD(1.5212,1,1,1,"%D",1,0)
|
---|
| 96 | ;;=Domain by data type.
|
---|
| 97 | ;;^DD(1.5212,1,1,1,"DT")
|
---|
| 98 | ;;=2960909
|
---|
| 99 | ;;^DD(1.5212,1,3)
|
---|
| 100 | ;;=
|
---|
| 101 | ;;^DD(1.5212,1,9)
|
---|
| 102 | ;;=^
|
---|
| 103 | ;;^DD(1.5212,1,21,0)
|
---|
| 104 | ;;=^^1^1^2960926^
|
---|
| 105 | ;;^DD(1.5212,1,21,1,0)
|
---|
| 106 | ;;=IEN of a standard data type in SQLI_DATA_TYPE. Required.
|
---|
| 107 | ;;^DD(1.5212,1,"DT")
|
---|
| 108 | ;;=2960909
|
---|
| 109 | ;;^DD(1.5212,2,0)
|
---|
| 110 | ;;=DM_COMMENT^F^^0;3^K:$L(X)>60!($L(X)<3) X
|
---|
| 111 | ;;^DD(1.5212,2,.1)
|
---|
| 112 | ;;=Comment
|
---|
| 113 | ;;^DD(1.5212,2,3)
|
---|
| 114 | ;;=Answer must be 3-60 characters in length.
|
---|
| 115 | ;;^DD(1.5212,2,9)
|
---|
| 116 | ;;=^
|
---|
| 117 | ;;^DD(1.5212,2,21,0)
|
---|
| 118 | ;;=^^1^1^2960926^
|
---|
| 119 | ;;^DD(1.5212,2,21,1,0)
|
---|
| 120 | ;;=A short comment which describes the data type set
|
---|
| 121 | ;;^DD(1.5212,2,"DT")
|
---|
| 122 | ;;=2960926
|
---|
| 123 | ;;^DD(1.5212,3,0)
|
---|
| 124 | ;;=DM_TABLE^P1.5215'^DMSQ("T",^0;4^Q
|
---|
| 125 | ;;^DD(1.5212,3,.1)
|
---|
| 126 | ;;=Table
|
---|
| 127 | ;;^DD(1.5212,3,1,0)
|
---|
| 128 | ;;=^.1
|
---|
| 129 | ;;^DD(1.5212,3,1,1,0)
|
---|
| 130 | ;;=1.5212^C
|
---|
| 131 | ;;^DD(1.5212,3,1,1,1)
|
---|
| 132 | ;;=S ^DMSQ("DM","C",$E(X,1,30),DA)=""
|
---|
| 133 | ;;^DD(1.5212,3,1,1,2)
|
---|
| 134 | ;;=K ^DMSQ("DM","C",$E(X,1,30),DA)
|
---|
| 135 | ;;^DD(1.5212,3,1,1,"%D",0)
|
---|
| 136 | ;;=^^1^1^2960823^
|
---|
| 137 | ;;^DD(1.5212,3,1,1,"%D",1,0)
|
---|
| 138 | ;;=Domain by table id
|
---|
| 139 | ;;^DD(1.5212,3,1,1,"DT")
|
---|
| 140 | ;;=2960823
|
---|
| 141 | ;;^DD(1.5212,3,3)
|
---|
| 142 | ;;=Enter only if domain is a table-id
|
---|
| 143 | ;;^DD(1.5212,3,9)
|
---|
| 144 | ;;=^
|
---|
| 145 | ;;^DD(1.5212,3,21,0)
|
---|
| 146 | ;;=^^2^2^2960926^
|
---|
| 147 | ;;^DD(1.5212,3,21,1,0)
|
---|
| 148 | ;;=IEN of table in SQLI_TABLE if domain is of type PRIMARY_KEY
|
---|
| 149 | ;;^DD(1.5212,3,21,2,0)
|
---|
| 150 | ;;=Only primary and foreign keys have such domains.
|
---|
| 151 | ;;^DD(1.5212,3,"DT")
|
---|
| 152 | ;;=2960926
|
---|
| 153 | ;;^DD(1.5212,4,0)
|
---|
| 154 | ;;=DM_WIDTH^NJ3,0^^0;5^K:+X'=X!(X>255)!(X<1)!(X?.E1"."1N.N) X
|
---|
| 155 | ;;^DD(1.5212,4,.1)
|
---|
| 156 | ;;=Width
|
---|
| 157 | ;;^DD(1.5212,4,3)
|
---|
| 158 | ;;=Type a Number between 1 and 255, 0 Decimal Digits
|
---|
| 159 | ;;^DD(1.5212,4,9)
|
---|
| 160 | ;;=^
|
---|
| 161 | ;;^DD(1.5212,4,21,0)
|
---|
| 162 | ;;=^^1^1^2960926^
|
---|
| 163 | ;;^DD(1.5212,4,21,1,0)
|
---|
| 164 | ;;=Default display width. Overrides data type display width.
|
---|
| 165 | ;;^DD(1.5212,4,"DT")
|
---|
| 166 | ;;=2960926
|
---|
| 167 | ;;^DD(1.5212,5,0)
|
---|
| 168 | ;;=DM_SCALE^NJ1,0^^0;6^K:+X'=X!(X>9)!(X<0)!(X?.E1"."1N.N) X
|
---|
| 169 | ;;^DD(1.5212,5,.1)
|
---|
| 170 | ;;=Scale
|
---|
| 171 | ;;^DD(1.5212,5,3)
|
---|
| 172 | ;;=Type a Number between 0 and 9, 0 Decimal Digits
|
---|
| 173 | ;;^DD(1.5212,5,9)
|
---|
| 174 | ;;=^
|
---|
| 175 | ;;^DD(1.5212,5,21,0)
|
---|
| 176 | ;;=^^1^1^2960926^
|
---|
| 177 | ;;^DD(1.5212,5,21,1,0)
|
---|
| 178 | ;;=Default number of decimal places displayed for numbers.
|
---|
| 179 | ;;^DD(1.5212,5,"DT")
|
---|
| 180 | ;;=2960926
|
---|
| 181 | ;;^DD(1.5212,6,0)
|
---|
| 182 | ;;=DM_OUTPUT_FORMAT^P1.5214'^DMSQ("OF",^0;7^Q
|
---|
| 183 | ;;^DD(1.5212,6,.1)
|
---|
| 184 | ;;=Output Format
|
---|
| 185 | ;;^DD(1.5212,6,3)
|
---|
| 186 | ;;=
|
---|
| 187 | ;;^DD(1.5212,6,9)
|
---|
| 188 | ;;=^
|
---|
| 189 | ;;^DD(1.5212,6,21,0)
|
---|
| 190 | ;;=^^2^2^2960926^
|
---|
| 191 | ;;^DD(1.5212,6,21,1,0)
|
---|
| 192 | ;;=Default output format for elements of this domain.
|
---|
| 193 | ;;^DD(1.5212,6,21,2,0)
|
---|
| 194 | ;;=Used to provide text value of pointer chains, etc.
|
---|
| 195 | ;;^DD(1.5212,6,"DT")
|
---|
| 196 | ;;=2960820
|
---|
| 197 | ;;^DD(1.5212,7,0)
|
---|
| 198 | ;;=DM_INT_EXPR^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
| 199 | ;;^DD(1.5212,7,.1)
|
---|
| 200 | ;;=Base to Internal Expression
|
---|
| 201 | ;;^DD(1.5212,7,3)
|
---|
| 202 | ;;=This is a Standard M expression to format X for output
|
---|
| 203 | ;;^DD(1.5212,7,9)
|
---|
| 204 | ;;=^
|
---|
| 205 | ;;^DD(1.5212,7,21,0)
|
---|
| 206 | ;;=^^2^2^2960926^
|
---|
| 207 | ;;^DD(1.5212,7,21,1,0)
|
---|
| 208 | ;;=An M expression which returns the internal value of a base value.
|
---|
| 209 | ;;^DD(1.5212,7,21,2,0)
|
---|
| 210 | ;;=Expression uses placeholder {B} to represent the base value
|
---|
| 211 | ;;^DD(1.5212,7,"DT")
|
---|
| 212 | ;;=2960926
|
---|
| 213 | ;;^DD(1.5212,8,0)
|
---|
| 214 | ;;=DM_INT_EXEC^K^^2;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
| 215 | ;;^DD(1.5212,8,.1)
|
---|
| 216 | ;;=Base to Internal Execute
|
---|
| 217 | ;;^DD(1.5212,8,3)
|
---|
| 218 | ;;=This is Standard MUMPS code to format X for input
|
---|
| 219 | ;;^DD(1.5212,8,9)
|
---|
| 220 | ;;=^
|
---|
| 221 | ;;^DD(1.5212,8,21,0)
|
---|
| 222 | ;;=^^2^2^2960926^
|
---|
| 223 | ;;^DD(1.5212,8,21,1,0)
|
---|
| 224 | ;;=M code line which sets internal value, {I}, to some function of base
|
---|
| 225 | ;;^DD(1.5212,8,21,2,0)
|
---|
| 226 | ;;=value, {B}.
|
---|
| 227 | ;;^DD(1.5212,8,"DT")
|
---|
| 228 | ;;=2960926
|
---|
| 229 | ;;^DD(1.5212,9,0)
|
---|
| 230 | ;;=DM_BASE_EXPR^K^^3;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
| 231 | ;;^DD(1.5212,9,.1)
|
---|
| 232 | ;;=Internal to Base Expression
|
---|
| 233 | ;;^DD(1.5212,9,3)
|
---|
| 234 | ;;=This is a Standard M expression to format X in internal form.
|
---|
| 235 | ;;^DD(1.5212,9,9)
|
---|
| 236 | ;;=^
|
---|
| 237 | ;;^DD(1.5212,9,21,0)
|
---|
| 238 | ;;=^^1^1^2960926^
|
---|
| 239 | ;;^DD(1.5212,9,21,1,0)
|
---|
| 240 | ;;=An M expression which returns the internal value of base value, {B}.
|
---|
| 241 | ;;^DD(1.5212,9,"DT")
|
---|
| 242 | ;;=2960926
|
---|
| 243 | ;;^DD(1.5212,10,0)
|
---|
| 244 | ;;=DM_BASE_EXEC^K^^4;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
| 245 | ;;^DD(1.5212,10,3)
|
---|
| 246 | ;;=This is Standard MUMPS code.
|
---|
| 247 | ;;^DD(1.5212,10,9)
|
---|
| 248 | ;;=^
|
---|
| 249 | ;;^DD(1.5212,10,21,0)
|
---|
| 250 | ;;=^^1^1^2960820^
|
---|