Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Routine: DINIT2BC

DINIT2BC.m

Go to the documentation of this file.
  1. DINIT2BC ;SFISC/MKO-SQLI FILES ;10:51 AM 30 Mar 1999
  1. ;;22.2;VA FileMan;;Jan 05, 2016;Build 42
  1. ;;Per VA Directive 6402, this routine should not be modified.
  1. ;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
  1. ;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
  1. ;;Licensed under the terms of the Apache License, Version 2.0.
  1. ;
  1. 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
  1. G ^DINIT2BD
  1. Q Q
  1. ;;^DIC(1.5219,0,"GL")
  1. ;;=^DMSQ("F",
  1. ;;^DIC("B","SQLI_FOREIGN_KEY",1.5219)
  1. ;;=
  1. ;;^DIC(1.5219,"%D",0)
  1. ;;=^^6^6^2970806^^^^
  1. ;;^DIC(1.5219,"%D",1,0)
  1. ;;=A set of columns in a table that match the primary key of another table.
  1. ;;^DIC(1.5219,"%D",2,0)
  1. ;;= They represent an explicit join of the two tables. Each foreign key
  1. ;;^DIC(1.5219,"%D",3,0)
  1. ;;= element points to it's table element (SQLI_TABLE_ELEMENT),
  1. ;;^DIC(1.5219,"%D",4,0)
  1. ;;=a column in the local table (SQLI_COLUMN) and a primary key element of a
  1. ;;^DIC(1.5219,"%D",5,0)
  1. ;;= foreign table (SQLI_PRIMARY_KEY). The primary key table element of the
  1. ;;^DIC(1.5219,"%D",6,0)
  1. ;;=foreign table has the domain of that table, which makes the connection.
  1. ;;^DD(1.5219,0)
  1. ;;=FIELD^^2^3
  1. ;;^DD(1.5219,0,"DDA")
  1. ;;=N
  1. ;;^DD(1.5219,0,"DT")
  1. ;;=2960820
  1. ;;^DD(1.5219,0,"IX","B",1.5219,.01)
  1. ;;=
  1. ;;^DD(1.5219,0,"NM","SQLI_FOREIGN_KEY")
  1. ;;=
  1. ;;^DD(1.5219,0,"VRPK")
  1. ;;=DI
  1. ;;^DD(1.5219,.01,0)
  1. ;;=F_TBL_ELEMENT^RP1.5216'^DMSQ("E",^0;1^Q
  1. ;;^DD(1.5219,.01,.1)
  1. ;;=Foreign Key
  1. ;;^DD(1.5219,.01,1,0)
  1. ;;=^.1
  1. ;;^DD(1.5219,.01,1,1,0)
  1. ;;=1.5219^B
  1. ;;^DD(1.5219,.01,1,1,1)
  1. ;;=S ^DMSQ("F","B",$E(X,1,30),DA)=""
  1. ;;^DD(1.5219,.01,1,1,2)
  1. ;;=K ^DMSQ("F","B",$E(X,1,30),DA)
  1. ;;^DD(1.5219,.01,3)
  1. ;;=
  1. ;;^DD(1.5219,.01,9)
  1. ;;=^
  1. ;;^DD(1.5219,.01,21,0)
  1. ;;=^^1^1^2960926^^^^
  1. ;;^DD(1.5219,.01,21,1,0)
  1. ;;=IEN of foreign key table element in SQLI_TABLE_ELEMENT
  1. ;;^DD(1.5219,.01,"DT")
  1. ;;=2960828
  1. ;;^DD(1.5219,1,0)
  1. ;;=F_PK_ELEMENT^RP1.5218'^DMSQ("P",^0;2^Q
  1. ;;^DD(1.5219,1,.1)
  1. ;;=Primary Key
  1. ;;^DD(1.5219,1,9)
  1. ;;=^
  1. ;;^DD(1.5219,1,21,0)
  1. ;;=^^1^1^2960926^
  1. ;;^DD(1.5219,1,21,1,0)
  1. ;;=IEN of primary key element in SQLI_PRIMARY_KEY of foreign table
  1. ;;^DD(1.5219,1,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5219,2,0)
  1. ;;=F_CLM_ELEMENT^RP1.5217'^DMSQ("C",^0;3^Q
  1. ;;^DD(1.5219,2,.1)
  1. ;;=Column
  1. ;;^DD(1.5219,2,9)
  1. ;;=^
  1. ;;^DD(1.5219,2,21,0)
  1. ;;=^^1^1^2960926^
  1. ;;^DD(1.5219,2,21,1,0)
  1. ;;=IEN of column of this table in SQLI_COLUMN which matches foreign PK
  1. ;;^DD(1.5219,2,"DT")
  1. ;;=2960926