- 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 Feb 19, 2025@00:17:49 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
