DINIT2B1.m

DINIT2B1 ;SFISC/MKO-SQLI FILES ;10:51 AM  30 Mar 1999

 ;;22.0;VA FileMan;;Mar 30, 1999

 ;Per VHA Directive 10-93-142, this routine should not be modified.

 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

DINIT2B1  ;SFISC/MKO-SQLI FILES ;10:51 AM  30 Mar 1999

 +1       ;;22.0;VA FileMan;;Mar 30, 1999

 +2       ;Per VHA Directive 10-93-142, this routine should not be modified.

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

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