1 | DINIT2B0 ;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 ^DINIT2B1
|
---|
6 | Q Q
|
---|
7 | ;;^DIC(1.521,0,"GL")
|
---|
8 | ;;=^DMSQ("S",
|
---|
9 | ;;^DIC("B","SQLI_SCHEMA",1.521)
|
---|
10 | ;;=
|
---|
11 | ;;^DIC(1.521,"%D",0)
|
---|
12 | ;;=^^1^1^2970806^^^
|
---|
13 | ;;^DIC(1.521,"%D",1,0)
|
---|
14 | ;;=A set of tables and domains. A subset of catalog and environment
|
---|
15 | ;;^DD(1.521,0)
|
---|
16 | ;;=FIELD^^2^3
|
---|
17 | ;;^DD(1.521,0,"DDA")
|
---|
18 | ;;=N
|
---|
19 | ;;^DD(1.521,0,"DT")
|
---|
20 | ;;=2960820
|
---|
21 | ;;^DD(1.521,0,"IX","B",1.521,.01)
|
---|
22 | ;;=
|
---|
23 | ;;^DD(1.521,0,"NM","SQLI_SCHEMA")
|
---|
24 | ;;=
|
---|
25 | ;;^DD(1.521,0,"PT",1.5215,1)
|
---|
26 | ;;=
|
---|
27 | ;;^DD(1.521,0,"VRPK")
|
---|
28 | ;;=DI
|
---|
29 | ;;^DD(1.521,.01,0)
|
---|
30 | ;;=S_NAME^RF^^0;1^K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X
|
---|
31 | ;;^DD(1.521,.01,.1)
|
---|
32 | ;;=Schema
|
---|
33 | ;;^DD(1.521,.01,1,0)
|
---|
34 | ;;=^.1
|
---|
35 | ;;^DD(1.521,.01,1,1,0)
|
---|
36 | ;;=1.521^B
|
---|
37 | ;;^DD(1.521,.01,1,1,1)
|
---|
38 | ;;=S ^DMSQ("S","B",$E(X,1,30),DA)=""
|
---|
39 | ;;^DD(1.521,.01,1,1,2)
|
---|
40 | ;;=K ^DMSQ("S","B",$E(X,1,30),DA)
|
---|
41 | ;;^DD(1.521,.01,3)
|
---|
42 | ;;=SQL identifier start with upper case letter, only letters, numbers and _.
|
---|
43 | ;;^DD(1.521,.01,9)
|
---|
44 | ;;=^
|
---|
45 | ;;^DD(1.521,.01,21,0)
|
---|
46 | ;;=^^2^2^2960926^^
|
---|
47 | ;;^DD(1.521,.01,21,1,0)
|
---|
48 | ;;=In FileMan, application groups are assigned SQL schema names
|
---|
49 | ;;^DD(1.521,.01,21,2,0)
|
---|
50 | ;;=Names are valid SQL identifiers, and are unique by site
|
---|
51 | ;;^DD(1.521,.01,"DT")
|
---|
52 | ;;=2960820
|
---|
53 | ;;^DD(1.521,1,0)
|
---|
54 | ;;=S_SECURITY^F^^1;1^K:$L(X)>12!($L(X)<4) X
|
---|
55 | ;;^DD(1.521,1,.1)
|
---|
56 | ;;=Security
|
---|
57 | ;;^DD(1.521,1,3)
|
---|
58 | ;;=Answer must be 4-12 characters in length.
|
---|
59 | ;;^DD(1.521,1,4)
|
---|
60 | ;;=W ?5,"Routine to check access to schema"
|
---|
61 | ;;^DD(1.521,1,9)
|
---|
62 | ;;=^
|
---|
63 | ;;^DD(1.521,1,21,0)
|
---|
64 | ;;=^^1^1^2970311^^^^
|
---|
65 | ;;^DD(1.521,1,21,1,0)
|
---|
66 | ;;=A routine to check security by application group.
|
---|
67 | ;;^DD(1.521,1,"DT")
|
---|
68 | ;;=2960926
|
---|
69 | ;;^DD(1.521,2,0)
|
---|
70 | ;;=S_DESCRIPTION^F^^0;2^K:$L(X)>60!($L(X)<3) X
|
---|
71 | ;;^DD(1.521,2,.1)
|
---|
72 | ;;=Description
|
---|
73 | ;;^DD(1.521,2,3)
|
---|
74 | ;;=Describe schema. Answer must be 3-60 characters in length.
|
---|
75 | ;;^DD(1.521,2,9)
|
---|
76 | ;;=^
|
---|
77 | ;;^DD(1.521,2,21,0)
|
---|
78 | ;;=^^1^1^2960926^
|
---|
79 | ;;^DD(1.521,2,21,1,0)
|
---|
80 | ;;=A short description of the schema
|
---|
81 | ;;^DD(1.521,2,"DT")
|
---|
82 | ;;=2960820
|
---|