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

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

initial load of WorldVistAEHR

File size: 2.3 KB
Line 
1DINIT2BC ;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 ^DINIT2BD
6Q Q
7 ;;^DIC(1.5219,0,"GL")
8 ;;=^DMSQ("F",
9 ;;^DIC("B","SQLI_FOREIGN_KEY",1.5219)
10 ;;=
11 ;;^DIC(1.5219,"%D",0)
12 ;;=^^6^6^2970806^^^^
13 ;;^DIC(1.5219,"%D",1,0)
14 ;;=A set of columns in a table that match the primary key of another table.
15 ;;^DIC(1.5219,"%D",2,0)
16 ;;= They represent an explicit join of the two tables. Each foreign key
17 ;;^DIC(1.5219,"%D",3,0)
18 ;;= element points to it's table element (SQLI_TABLE_ELEMENT),
19 ;;^DIC(1.5219,"%D",4,0)
20 ;;=a column in the local table (SQLI_COLUMN) and a primary key element of a
21 ;;^DIC(1.5219,"%D",5,0)
22 ;;= foreign table (SQLI_PRIMARY_KEY). The primary key table element of the
23 ;;^DIC(1.5219,"%D",6,0)
24 ;;=foreign table has the domain of that table, which makes the connection.
25 ;;^DD(1.5219,0)
26 ;;=FIELD^^2^3
27 ;;^DD(1.5219,0,"DDA")
28 ;;=N
29 ;;^DD(1.5219,0,"DT")
30 ;;=2960820
31 ;;^DD(1.5219,0,"IX","B",1.5219,.01)
32 ;;=
33 ;;^DD(1.5219,0,"NM","SQLI_FOREIGN_KEY")
34 ;;=
35 ;;^DD(1.5219,0,"VRPK")
36 ;;=DI
37 ;;^DD(1.5219,.01,0)
38 ;;=F_TBL_ELEMENT^RP1.5216'^DMSQ("E",^0;1^Q
39 ;;^DD(1.5219,.01,.1)
40 ;;=Foreign Key
41 ;;^DD(1.5219,.01,1,0)
42 ;;=^.1
43 ;;^DD(1.5219,.01,1,1,0)
44 ;;=1.5219^B
45 ;;^DD(1.5219,.01,1,1,1)
46 ;;=S ^DMSQ("F","B",$E(X,1,30),DA)=""
47 ;;^DD(1.5219,.01,1,1,2)
48 ;;=K ^DMSQ("F","B",$E(X,1,30),DA)
49 ;;^DD(1.5219,.01,3)
50 ;;=
51 ;;^DD(1.5219,.01,9)
52 ;;=^
53 ;;^DD(1.5219,.01,21,0)
54 ;;=^^1^1^2960926^^^^
55 ;;^DD(1.5219,.01,21,1,0)
56 ;;=IEN of foreign key table element in SQLI_TABLE_ELEMENT
57 ;;^DD(1.5219,.01,"DT")
58 ;;=2960828
59 ;;^DD(1.5219,1,0)
60 ;;=F_PK_ELEMENT^RP1.5218'^DMSQ("P",^0;2^Q
61 ;;^DD(1.5219,1,.1)
62 ;;=Primary Key
63 ;;^DD(1.5219,1,9)
64 ;;=^
65 ;;^DD(1.5219,1,21,0)
66 ;;=^^1^1^2960926^
67 ;;^DD(1.5219,1,21,1,0)
68 ;;=IEN of primary key element in SQLI_PRIMARY_KEY of foreign table
69 ;;^DD(1.5219,1,"DT")
70 ;;=2960926
71 ;;^DD(1.5219,2,0)
72 ;;=F_CLM_ELEMENT^RP1.5217'^DMSQ("C",^0;3^Q
73 ;;^DD(1.5219,2,.1)
74 ;;=Column
75 ;;^DD(1.5219,2,9)
76 ;;=^
77 ;;^DD(1.5219,2,21,0)
78 ;;=^^1^1^2960926^
79 ;;^DD(1.5219,2,21,1,0)
80 ;;=IEN of column of this table in SQLI_COLUMN which matches foreign PK
81 ;;^DD(1.5219,2,"DT")
82 ;;=2960926
Note: See TracBrowser for help on using the repository browser.