source: FOIAVistA/trunk/r/VA_FILEMAN-ARJT-DI-DD-DM-DT-%DT-%RCR/DINIT2B0.m@ 899

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

initial load of FOIAVistA 6/30/08 version

File size: 2.1 KB
Line 
1DINIT2B0 ;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 ^DINIT2B1
6Q Q
7 ;;^DIC(1.521,0,"GL")
8 ;;=^DMSQ("S",
9 ;;^DIC("B","SQLI_SCHEMA",1.521)
10 ;;=
11 ;;^DIC(1.521,"%D",0)
12 ;;=^^1^1^2970806^^^
13 ;;^DIC(1.521,"%D",1,0)
14 ;;=A set of tables and domains. A subset of catalog and environment
15 ;;^DD(1.521,0)
16 ;;=FIELD^^2^3
17 ;;^DD(1.521,0,"DDA")
18 ;;=N
19 ;;^DD(1.521,0,"DT")
20 ;;=2960820
21 ;;^DD(1.521,0,"IX","B",1.521,.01)
22 ;;=
23 ;;^DD(1.521,0,"NM","SQLI_SCHEMA")
24 ;;=
25 ;;^DD(1.521,0,"PT",1.5215,1)
26 ;;=
27 ;;^DD(1.521,0,"VRPK")
28 ;;=DI
29 ;;^DD(1.521,.01,0)
30 ;;=S_NAME^RF^^0;1^K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X
31 ;;^DD(1.521,.01,.1)
32 ;;=Schema
33 ;;^DD(1.521,.01,1,0)
34 ;;=^.1
35 ;;^DD(1.521,.01,1,1,0)
36 ;;=1.521^B
37 ;;^DD(1.521,.01,1,1,1)
38 ;;=S ^DMSQ("S","B",$E(X,1,30),DA)=""
39 ;;^DD(1.521,.01,1,1,2)
40 ;;=K ^DMSQ("S","B",$E(X,1,30),DA)
41 ;;^DD(1.521,.01,3)
42 ;;=SQL identifier start with upper case letter, only letters, numbers and _.
43 ;;^DD(1.521,.01,9)
44 ;;=^
45 ;;^DD(1.521,.01,21,0)
46 ;;=^^2^2^2960926^^
47 ;;^DD(1.521,.01,21,1,0)
48 ;;=In FileMan, application groups are assigned SQL schema names
49 ;;^DD(1.521,.01,21,2,0)
50 ;;=Names are valid SQL identifiers, and are unique by site
51 ;;^DD(1.521,.01,"DT")
52 ;;=2960820
53 ;;^DD(1.521,1,0)
54 ;;=S_SECURITY^F^^1;1^K:$L(X)>12!($L(X)<4) X
55 ;;^DD(1.521,1,.1)
56 ;;=Security
57 ;;^DD(1.521,1,3)
58 ;;=Answer must be 4-12 characters in length.
59 ;;^DD(1.521,1,4)
60 ;;=W ?5,"Routine to check access to schema"
61 ;;^DD(1.521,1,9)
62 ;;=^
63 ;;^DD(1.521,1,21,0)
64 ;;=^^1^1^2970311^^^^
65 ;;^DD(1.521,1,21,1,0)
66 ;;=A routine to check security by application group.
67 ;;^DD(1.521,1,"DT")
68 ;;=2960926
69 ;;^DD(1.521,2,0)
70 ;;=S_DESCRIPTION^F^^0;2^K:$L(X)>60!($L(X)<3) X
71 ;;^DD(1.521,2,.1)
72 ;;=Description
73 ;;^DD(1.521,2,3)
74 ;;=Describe schema. Answer must be 3-60 characters in length.
75 ;;^DD(1.521,2,9)
76 ;;=^
77 ;;^DD(1.521,2,21,0)
78 ;;=^^1^1^2960926^
79 ;;^DD(1.521,2,21,1,0)
80 ;;=A short description of the schema
81 ;;^DD(1.521,2,"DT")
82 ;;=2960820
Note: See TracBrowser for help on using the repository browser.