DINIT2B1 ;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 ^DINIT2B2
Q Q
;;^DIC(1.52101,0,"GL")
;;=^DMSQ("K",
;;^DIC("B","SQLI_KEY_WORD",1.52101)
;;=
;;^DIC(1.52101,"%D",0)
;;=^^3^3^2970806^^^
;;^DIC(1.52101,"%D",1,0)
;;=SQL identifiers that may not be used for column and table names.
;;^DIC(1.52101,"%D",2,0)
;;= SQL, ODBC and vendors all have lists of restricted words, which
;;^DIC(1.52101,"%D",3,0)
;;=should be put in this table before SQLI table generation.
;;^DD(1.52101,0)
;;=FIELD^^.01^1
;;^DD(1.52101,0,"DDA")
;;=N
;;^DD(1.52101,0,"DT")
;;=2970311
;;^DD(1.52101,0,"IX","B",1.52101,.01)
;;=
;;^DD(1.52101,0,"NM","SQLI_KEY_WORD")
;;=
;;^DD(1.52101,0,"VRPK")
;;=DI
;;^DD(1.52101,.01,0)
;;=KEY_WORD^RF^^0;1^K:$L(X)>30!($L(X)<2)!'($TR(X,"_")?1U.UN) X
;;^DD(1.52101,.01,.1)
;;=Keyword
;;^DD(1.52101,.01,1,0)
;;=^.1
;;^DD(1.52101,.01,1,1,0)
;;=1.52101^B
;;^DD(1.52101,.01,1,1,1)
;;=S ^DMSQ("K","B",$E(X,1,30),DA)=""
;;^DD(1.52101,.01,1,1,2)
;;=K ^DMSQ("K","B",$E(X,1,30),DA)
;;^DD(1.52101,.01,3)
;;=Answer must be 2-30 characters in length.
;;^DD(1.52101,.01,9)
;;=^
;;^DD(1.52101,.01,"DT")
;;=2970311
--- Routine Detail --- with STRUCTURED ROUTINE LISTING ---[H[J[2J[HDINIT2B1 1652 printed Nov 22, 2024@18:01:31 Page 2
DINIT2B1 ;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 ^DINIT2B2
Q QUIT
+1 ;;^DIC(1.52101,0,"GL")
+2 ;;=^DMSQ("K",
+3 ;;^DIC("B","SQLI_KEY_WORD",1.52101)
+4 ;;=
+5 ;;^DIC(1.52101,"%D",0)
+6 ;;=^^3^3^2970806^^^
+7 ;;^DIC(1.52101,"%D",1,0)
+8 ;;=SQL identifiers that may not be used for column and table names.
+9 ;;^DIC(1.52101,"%D",2,0)
+10 ;;= SQL, ODBC and vendors all have lists of restricted words, which
+11 ;;^DIC(1.52101,"%D",3,0)
+12 ;;=should be put in this table before SQLI table generation.
+13 ;;^DD(1.52101,0)
+14 ;;=FIELD^^.01^1
+15 ;;^DD(1.52101,0,"DDA")
+16 ;;=N
+17 ;;^DD(1.52101,0,"DT")
+18 ;;=2970311
+19 ;;^DD(1.52101,0,"IX","B",1.52101,.01)
+20 ;;=
+21 ;;^DD(1.52101,0,"NM","SQLI_KEY_WORD")
+22 ;;=
+23 ;;^DD(1.52101,0,"VRPK")
+24 ;;=DI
+25 ;;^DD(1.52101,.01,0)
+26 ;;=KEY_WORD^RF^^0;1^K:$L(X)>30!($L(X)<2)!'($TR(X,"_")?1U.UN) X
+27 ;;^DD(1.52101,.01,.1)
+28 ;;=Keyword
+29 ;;^DD(1.52101,.01,1,0)
+30 ;;=^.1
+31 ;;^DD(1.52101,.01,1,1,0)
+32 ;;=1.52101^B
+33 ;;^DD(1.52101,.01,1,1,1)
+34 ;;=S ^DMSQ("K","B",$E(X,1,30),DA)=""
+35 ;;^DD(1.52101,.01,1,1,2)
+36 ;;=K ^DMSQ("K","B",$E(X,1,30),DA)
+37 ;;^DD(1.52101,.01,3)
+38 ;;=Answer must be 2-30 characters in length.
+39 ;;^DD(1.52101,.01,9)
+40 ;;=^
+41 ;;^DD(1.52101,.01,"DT")
+42 ;;=2970311
