1 | DINIT2B5 ;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 ^DINIT2B6
|
---|
6 | Q Q
|
---|
7 | ;;^DIC(1.5213,0,"GL")
|
---|
8 | ;;=^DMSQ("KF",
|
---|
9 | ;;^DIC("B","SQLI_KEY_FORMAT",1.5213)
|
---|
10 | ;;=
|
---|
11 | ;;^DIC(1.5213,"%D",0)
|
---|
12 | ;;=^^5^5^2970806^^^
|
---|
13 | ;;^DIC(1.5213,"%D",1,0)
|
---|
14 | ;;=Strategies for converting base values into key values.
|
---|
15 | ;;^DIC(1.5213,"%D",2,0)
|
---|
16 | ;;=Soundex and upper case conversion are common examples. This implies that
|
---|
17 | ;;^DIC(1.5213,"%D",3,0)
|
---|
18 | ;;=comparisons of key values with base values must be preceded by conversion
|
---|
19 | ;;^DIC(1.5213,"%D",4,0)
|
---|
20 | ;;=of the base value to key value. Key formats are frequently lossy; they
|
---|
21 | ;;^DIC(1.5213,"%D",5,0)
|
---|
22 | ;;=can't be converted uniquely back to base format.
|
---|
23 | ;;^DD(1.5213,0)
|
---|
24 | ;;=FIELD^^4^5
|
---|
25 | ;;^DD(1.5213,0,"DDA")
|
---|
26 | ;;=N
|
---|
27 | ;;^DD(1.5213,0,"DT")
|
---|
28 | ;;=2960820
|
---|
29 | ;;^DD(1.5213,0,"IX","B",1.5213,.01)
|
---|
30 | ;;=
|
---|
31 | ;;^DD(1.5213,0,"IX","C",1.5213,1)
|
---|
32 | ;;=
|
---|
33 | ;;^DD(1.5213,0,"NM","SQLI_KEY_FORMAT")
|
---|
34 | ;;=
|
---|
35 | ;;^DD(1.5213,0,"PT",1.5218,7)
|
---|
36 | ;;=
|
---|
37 | ;;^DD(1.5213,0,"VRPK")
|
---|
38 | ;;=DI
|
---|
39 | ;;^DD(1.5213,.01,0)
|
---|
40 | ;;=KF_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
|
---|
41 | ;;^DD(1.5213,.01,.1)
|
---|
42 | ;;=Key Format
|
---|
43 | ;;^DD(1.5213,.01,1,0)
|
---|
44 | ;;=^.1
|
---|
45 | ;;^DD(1.5213,.01,1,1,0)
|
---|
46 | ;;=1.5213^B
|
---|
47 | ;;^DD(1.5213,.01,1,1,1)
|
---|
48 | ;;=S ^DMSQ("KF","B",$E(X,1,30),DA)=""
|
---|
49 | ;;^DD(1.5213,.01,1,1,2)
|
---|
50 | ;;=K ^DMSQ("KF","B",$E(X,1,30),DA)
|
---|
51 | ;;^DD(1.5213,.01,3)
|
---|
52 | ;;=Answer must be 3-30 characters in length.
|
---|
53 | ;;^DD(1.5213,.01,9)
|
---|
54 | ;;=^
|
---|
55 | ;;^DD(1.5213,.01,"DT")
|
---|
56 | ;;=2960820
|
---|
57 | ;;^DD(1.5213,1,0)
|
---|
58 | ;;=KF_DATA_TYPE^RP1.5211'^DMSQ("DT",^0;2^Q
|
---|
59 | ;;^DD(1.5213,1,1,0)
|
---|
60 | ;;=^.1
|
---|
61 | ;;^DD(1.5213,1,1,1,0)
|
---|
62 | ;;=1.5213^C
|
---|
63 | ;;^DD(1.5213,1,1,1,1)
|
---|
64 | ;;=S ^DMSQ("KF","C",$E(X,1,30),DA)=""
|
---|
65 | ;;^DD(1.5213,1,1,1,2)
|
---|
66 | ;;=K ^DMSQ("KF","C",$E(X,1,30),DA)
|
---|
67 | ;;^DD(1.5213,1,1,1,"%D",0)
|
---|
68 | ;;=^^1^1^2960823^
|
---|
69 | ;;^DD(1.5213,1,1,1,"%D",1,0)
|
---|
70 | ;;=KEY FORMAT BY DATA TYPE
|
---|
71 | ;;^DD(1.5213,1,1,1,"DT")
|
---|
72 | ;;=2960823
|
---|
73 | ;;^DD(1.5213,1,3)
|
---|
74 | ;;=Enter the ODBC data type of this key
|
---|
75 | ;;^DD(1.5213,1,9)
|
---|
76 | ;;=^
|
---|
77 | ;;^DD(1.5213,1,"DT")
|
---|
78 | ;;=2960823
|
---|
79 | ;;^DD(1.5213,2,0)
|
---|
80 | ;;=KF_COMMENT^F^^0;3^K:$L(X)>60!($L(X)<3) X
|
---|
81 | ;;^DD(1.5213,2,3)
|
---|
82 | ;;=Answer must be 3-60 characters in length.
|
---|
83 | ;;^DD(1.5213,2,9)
|
---|
84 | ;;=^
|
---|
85 | ;;^DD(1.5213,2,"DT")
|
---|
86 | ;;=2960820
|
---|
87 | ;;^DD(1.5213,3,0)
|
---|
88 | ;;=KF_INT_EXPR^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
89 | ;;^DD(1.5213,3,3)
|
---|
90 | ;;=This is Standard MUMPS code.
|
---|
91 | ;;^DD(1.5213,3,9)
|
---|
92 | ;;=^
|
---|
93 | ;;^DD(1.5213,3,21,0)
|
---|
94 | ;;=^^1^1^2960820^
|
---|
95 | ;;^DD(1.5213,3,21,1,0)
|
---|
96 | ;;=An M expression which converts X to it's key format
|
---|
97 | ;;^DD(1.5213,3,"DT")
|
---|
98 | ;;=2960820
|
---|
99 | ;;^DD(1.5213,4,0)
|
---|
100 | ;;=KF_INT_EXEC^K^^2;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
|
---|
101 | ;;^DD(1.5213,4,3)
|
---|
102 | ;;=This is Standard MUMPS code.
|
---|
103 | ;;^DD(1.5213,4,9)
|
---|
104 | ;;=^
|
---|
105 | ;;^DD(1.5213,4,21,0)
|
---|
106 | ;;=^^1^1^2960820^
|
---|
107 | ;;^DD(1.5213,4,21,1,0)
|
---|
108 | ;;=A line of M code which converts X to its key format
|
---|
109 | ;;^DD(1.5213,4,"DT")
|
---|
110 | ;;=2960820
|
---|