DINIT2B0 ;SFISC/MKO-SQLI FILES ;10:51 AM 30 Mar 1999
;;22.2;VA FileMan;;Jan 05, 2016;Build 42
;;Per VA Directive 6402, this routine should not be modified.
;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
;;Licensed under the terms of the Apache License, Version 2.0.
;
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
G ^DINIT2B1
Q Q
;;^DIC(1.521,0,"GL")
;;=^DMSQ("S",
;;^DIC("B","SQLI_SCHEMA",1.521)
;;=
;;^DIC(1.521,"%D",0)
;;=^^1^1^2970806^^^
;;^DIC(1.521,"%D",1,0)
;;=A set of tables and domains. A subset of catalog and environment
;;^DD(1.521,0)
;;=FIELD^^2^3
;;^DD(1.521,0,"DDA")
;;=N
;;^DD(1.521,0,"DT")
;;=2960820
;;^DD(1.521,0,"IX","B",1.521,.01)
;;=
;;^DD(1.521,0,"NM","SQLI_SCHEMA")
;;=
;;^DD(1.521,0,"PT",1.5215,1)
;;=
;;^DD(1.521,0,"VRPK")
;;=DI
;;^DD(1.521,.01,0)
;;=S_NAME^RF^^0;1^K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X
;;^DD(1.521,.01,.1)
;;=Schema
;;^DD(1.521,.01,1,0)
;;=^.1
;;^DD(1.521,.01,1,1,0)
;;=1.521^B
;;^DD(1.521,.01,1,1,1)
;;=S ^DMSQ("S","B",$E(X,1,30),DA)=""
;;^DD(1.521,.01,1,1,2)
;;=K ^DMSQ("S","B",$E(X,1,30),DA)
;;^DD(1.521,.01,3)
;;=SQL identifier start with upper case letter, only letters, numbers and _.
;;^DD(1.521,.01,9)
;;=^
;;^DD(1.521,.01,21,0)
;;=^^2^2^2960926^^
;;^DD(1.521,.01,21,1,0)
;;=In FileMan, application groups are assigned SQL schema names
;;^DD(1.521,.01,21,2,0)
;;=Names are valid SQL identifiers, and are unique by site
;;^DD(1.521,.01,"DT")
;;=2960820
;;^DD(1.521,1,0)
;;=S_SECURITY^F^^1;1^K:$L(X)>12!($L(X)<4) X
;;^DD(1.521,1,.1)
;;=Security
;;^DD(1.521,1,3)
;;=Answer must be 4-12 characters in length.
;;^DD(1.521,1,4)
;;=W ?5,"Routine to check access to schema"
;;^DD(1.521,1,9)
;;=^
;;^DD(1.521,1,21,0)
;;=^^1^1^2970311^^^^
;;^DD(1.521,1,21,1,0)
;;=A routine to check security by application group.
;;^DD(1.521,1,"DT")
;;=2960926
;;^DD(1.521,2,0)
;;=S_DESCRIPTION^F^^0;2^K:$L(X)>60!($L(X)<3) X
;;^DD(1.521,2,.1)
;;=Description
;;^DD(1.521,2,3)
;;=Describe schema. Answer must be 3-60 characters in length.
;;^DD(1.521,2,9)
;;=^
;;^DD(1.521,2,21,0)
;;=^^1^1^2960926^
;;^DD(1.521,2,21,1,0)
;;=A short description of the schema
;;^DD(1.521,2,"DT")
;;=2960820
--- Routine Detail --- with STRUCTURED ROUTINE LISTING ---[H[J[2J[HDINIT2B0 2476 printed Dec 13, 2024@02:51:33 Page 2
DINIT2B0 ;SFISC/MKO-SQLI FILES ;10:51 AM 30 Mar 1999
+1 ;;22.2;VA FileMan;;Jan 05, 2016;Build 42
+2 ;;Per VA Directive 6402, this routine should not be modified.
+3 ;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
+4 ;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
+5 ;;Licensed under the terms of the Apache License, Version 2.0.
+6 ;
+7 FOR I=1:2
SET X=$TEXT(Q+I)
if X=""
QUIT
SET Y=$EXTRACT($TEXT(Q+I+1),4,999)
SET X=$EXTRACT(X,4,999)
if $ASCII(Y)=126
SET I=I+1
SET Y=$EXTRACT(Y,2,999)_$EXTRACT($TEXT(Q+I+1),5,99)
if $ASCII(Y)=61
SET Y=$EXTRACT(Y,2,999)
SET @X=Y
+8 GOTO ^DINIT2B1
Q QUIT
+1 ;;^DIC(1.521,0,"GL")
+2 ;;=^DMSQ("S",
+3 ;;^DIC("B","SQLI_SCHEMA",1.521)
+4 ;;=
+5 ;;^DIC(1.521,"%D",0)
+6 ;;=^^1^1^2970806^^^
+7 ;;^DIC(1.521,"%D",1,0)
+8 ;;=A set of tables and domains. A subset of catalog and environment
+9 ;;^DD(1.521,0)
+10 ;;=FIELD^^2^3
+11 ;;^DD(1.521,0,"DDA")
+12 ;;=N
+13 ;;^DD(1.521,0,"DT")
+14 ;;=2960820
+15 ;;^DD(1.521,0,"IX","B",1.521,.01)
+16 ;;=
+17 ;;^DD(1.521,0,"NM","SQLI_SCHEMA")
+18 ;;=
+19 ;;^DD(1.521,0,"PT",1.5215,1)
+20 ;;=
+21 ;;^DD(1.521,0,"VRPK")
+22 ;;=DI
+23 ;;^DD(1.521,.01,0)
+24 ;;=S_NAME^RF^^0;1^K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X
+25 ;;^DD(1.521,.01,.1)
+26 ;;=Schema
+27 ;;^DD(1.521,.01,1,0)
+28 ;;=^.1
+29 ;;^DD(1.521,.01,1,1,0)
+30 ;;=1.521^B
+31 ;;^DD(1.521,.01,1,1,1)
+32 ;;=S ^DMSQ("S","B",$E(X,1,30),DA)=""
+33 ;;^DD(1.521,.01,1,1,2)
+34 ;;=K ^DMSQ("S","B",$E(X,1,30),DA)
+35 ;;^DD(1.521,.01,3)
+36 ;;=SQL identifier start with upper case letter, only letters, numbers and _.
+37 ;;^DD(1.521,.01,9)
+38 ;;=^
+39 ;;^DD(1.521,.01,21,0)
+40 ;;=^^2^2^2960926^^
+41 ;;^DD(1.521,.01,21,1,0)
+42 ;;=In FileMan, application groups are assigned SQL schema names
+43 ;;^DD(1.521,.01,21,2,0)
+44 ;;=Names are valid SQL identifiers, and are unique by site
+45 ;;^DD(1.521,.01,"DT")
+46 ;;=2960820
+47 ;;^DD(1.521,1,0)
+48 ;;=S_SECURITY^F^^1;1^K:$L(X)>12!($L(X)<4) X
+49 ;;^DD(1.521,1,.1)
+50 ;;=Security
+51 ;;^DD(1.521,1,3)
+52 ;;=Answer must be 4-12 characters in length.
+53 ;;^DD(1.521,1,4)
+54 ;;=W ?5,"Routine to check access to schema"
+55 ;;^DD(1.521,1,9)
+56 ;;=^
+57 ;;^DD(1.521,1,21,0)
+58 ;;=^^1^1^2970311^^^^
+59 ;;^DD(1.521,1,21,1,0)
+60 ;;=A routine to check security by application group.
+61 ;;^DD(1.521,1,"DT")
+62 ;;=2960926
+63 ;;^DD(1.521,2,0)
+64 ;;=S_DESCRIPTION^F^^0;2^K:$L(X)>60!($L(X)<3) X
+65 ;;^DD(1.521,2,.1)
+66 ;;=Description
+67 ;;^DD(1.521,2,3)
+68 ;;=Describe schema. Answer must be 3-60 characters in length.
+69 ;;^DD(1.521,2,9)
+70 ;;=^
+71 ;;^DD(1.521,2,21,0)
+72 ;;=^^1^1^2960926^
+73 ;;^DD(1.521,2,21,1,0)
+74 ;;=A short description of the schema
+75 ;;^DD(1.521,2,"DT")
+76 ;;=2960820
