| 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 | 
|---|