source: WorldVistAEHR/trunk/r/VA_FILEMAN-ARJT-DI-DD-DM-DT-%DT-%RCR/DINIT2B1.m@ 1361

Last change on this file since 1361 was 613, checked in by George Lilly, 15 years ago

initial load of WorldVistAEHR

File size: 1.4 KB
RevLine 
[613]1DINIT2B1 ;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 ^DINIT2B2
6Q Q
7 ;;^DIC(1.52101,0,"GL")
8 ;;=^DMSQ("K",
9 ;;^DIC("B","SQLI_KEY_WORD",1.52101)
10 ;;=
11 ;;^DIC(1.52101,"%D",0)
12 ;;=^^3^3^2970806^^^
13 ;;^DIC(1.52101,"%D",1,0)
14 ;;=SQL identifiers that may not be used for column and table names.
15 ;;^DIC(1.52101,"%D",2,0)
16 ;;= SQL, ODBC and vendors all have lists of restricted words, which
17 ;;^DIC(1.52101,"%D",3,0)
18 ;;=should be put in this table before SQLI table generation.
19 ;;^DD(1.52101,0)
20 ;;=FIELD^^.01^1
21 ;;^DD(1.52101,0,"DDA")
22 ;;=N
23 ;;^DD(1.52101,0,"DT")
24 ;;=2970311
25 ;;^DD(1.52101,0,"IX","B",1.52101,.01)
26 ;;=
27 ;;^DD(1.52101,0,"NM","SQLI_KEY_WORD")
28 ;;=
29 ;;^DD(1.52101,0,"VRPK")
30 ;;=DI
31 ;;^DD(1.52101,.01,0)
32 ;;=KEY_WORD^RF^^0;1^K:$L(X)>30!($L(X)<2)!'($TR(X,"_")?1U.UN) X
33 ;;^DD(1.52101,.01,.1)
34 ;;=Keyword
35 ;;^DD(1.52101,.01,1,0)
36 ;;=^.1
37 ;;^DD(1.52101,.01,1,1,0)
38 ;;=1.52101^B
39 ;;^DD(1.52101,.01,1,1,1)
40 ;;=S ^DMSQ("K","B",$E(X,1,30),DA)=""
41 ;;^DD(1.52101,.01,1,1,2)
42 ;;=K ^DMSQ("K","B",$E(X,1,30),DA)
43 ;;^DD(1.52101,.01,3)
44 ;;=Answer must be 2-30 characters in length.
45 ;;^DD(1.52101,.01,9)
46 ;;=^
47 ;;^DD(1.52101,.01,"DT")
48 ;;=2970311
Note: See TracBrowser for help on using the repository browser.