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