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

DINIT2B8.m

Go to the documentation of this file. 
  1. DINIT2B8 ;SFISC/MKO-SQLI FILES ;10:51 AM  30 Mar 1999
  1.  ;;22.0;VA FileMan;;Mar 30, 1999
  1.  ;Per VHA Directive 10-93-142, this routine should not be modified.
  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 ^DINIT2B9
  1. Q Q
  1.  ;;^DIC(1.5216,0,"GL")
  1.  ;;=^DMSQ("E",
  1.  ;;^DIC("B","SQLI_TABLE_ELEMENT",1.5216)
  1.  ;;=
  1.  ;;^DIC(1.5216,"%D",0)
  1.  ;;=^^5^5^2970806^^^
  1.  ;;^DIC(1.5216,"%D",1,0)
  1.  ;;=Names and domains of primary keys, columns and foreign keys.
  1.  ;;^DIC(1.5216,"%D",2,0)
  1.  ;;=Each represents the relational concept of an attribute, whose essential
  1.  ;;^DIC(1.5216,"%D",3,0)
  1.  ;;=charactaristics are a name (unique by relation) and a domain.
  1.  ;;^DIC(1.5216,"%D",4,0)
  1.  ;;= 
  1.  ;;^DIC(1.5216,"%D",5,0)
  1.  ;;=See SQLI_PRIMARY_KEY, SQLI_COLUMN and SQLI_FOREIGN key for more.
  1.  ;;^DD(1.5216,0)
  1.  ;;=FIELD^^4^5
  1.  ;;^DD(1.5216,0,"DDA")
  1.  ;;=N
  1.  ;;^DD(1.5216,0,"DT")
  1.  ;;=2960820
  1.  ;;^DD(1.5216,0,"IX","B",1.5216,.01)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"IX","C",1.5216,1)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"IX","D",1.5216,2)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"IX","E",1.5216,3)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"IX","F",1.5216,3)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"IX","G",1.5216,2)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"NM","SQLI_TABLE_ELEMENT")
  1.  ;;=
  1.  ;;^DD(1.5216,0,"PT",1.5217,.01)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"PT",1.5218,.01)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"PT",1.5219,.01)
  1.  ;;=
  1.  ;;^DD(1.5216,0,"VRPK")
  1.  ;;=DI
  1.  ;;^DD(1.5216,.01,0)
  1.  ;;=E_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
  1.  ;;^DD(1.5216,.01,.1)
  1.  ;;=Table Element
  1.  ;;^DD(1.5216,.01,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5216,.01,1,1,0)
  1.  ;;=1.5216^B
  1.  ;;^DD(1.5216,.01,1,1,1)
  1.  ;;=S ^DMSQ("E","B",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5216,.01,1,1,2)
  1.  ;;=K ^DMSQ("E","B",$E(X,1,30),DA)
  1.  ;;^DD(1.5216,.01,3)
  1.  ;;=Answer must be 3-30 characters in length.
  1.  ;;^DD(1.5216,.01,9)
  1.  ;;=^
  1.  ;;^DD(1.5216,.01,21,0)
  1.  ;;=^^2^2^2960926^
  1.  ;;^DD(1.5216,.01,21,1,0)
  1.  ;;=Name of table element.
  1.  ;;^DD(1.5216,.01,21,2,0)
  1.  ;;=Foreign keys are suffixed _FK or PFK. Primary keys are suffixed _PK.
  1.  ;;^DD(1.5216,.01,"DT")
  1.  ;;=2960820
  1.  ;;^DD(1.5216,1,0)
  1.  ;;=E_DOMAIN^RP1.5212'^DMSQ("DM",^0;2^Q
  1.  ;;^DD(1.5216,1,.1)
  1.  ;;=Domain
  1.  ;;^DD(1.5216,1,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5216,1,1,1,0)
  1.  ;;=1.5216^C
  1.  ;;^DD(1.5216,1,1,1,1)
  1.  ;;=S ^DMSQ("E","C",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5216,1,1,1,2)
  1.  ;;=K ^DMSQ("E","C",$E(X,1,30),DA)
  1.  ;;^DD(1.5216,1,1,1,"DT")
  1.  ;;=2960823
  1.  ;;^DD(1.5216,1,9)
  1.  ;;=^
  1.  ;;^DD(1.5216,1,21,0)
  1.  ;;=^^1^1^2960926^
  1.  ;;^DD(1.5216,1,21,1,0)
  1.  ;;=IEN of domain in SQLI_DOMAIN
  1.  ;;^DD(1.5216,1,"DT")
  1.  ;;=2960926
  1.  ;;^DD(1.5216,2,0)
  1.  ;;=E_TABLE^RP1.5215'^DMSQ("T",^0;3^Q
  1.  ;;^DD(1.5216,2,.1)
  1.  ;;=Table
  1.  ;;^DD(1.5216,2,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5216,2,1,1,0)
  1.  ;;=1.5216^D
  1.  ;;^DD(1.5216,2,1,1,1)
  1.  ;;=S ^DMSQ("E","D",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5216,2,1,1,2)
  1.  ;;=K ^DMSQ("E","D",$E(X,1,30),DA)
  1.  ;;^DD(1.5216,2,1,1,"DT")
  1.  ;;=2960823
  1.  ;;^DD(1.5216,2,1,2,0)
  1.  ;;=1.5216^G^MUMPS
  1.  ;;^DD(1.5216,2,1,2,1)
  1.  ;;=S ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)=""
  1.  ;;^DD(1.5216,2,1,2,2)
  1.  ;;=K ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)
  1.  ;;^DD(1.5216,2,1,2,"%D",0)
  1.  ;;=^^1^1^2960903^
  1.  ;;^DD(1.5216,2,1,2,"%D",1,0)
  1.  ;;=Table element by table by name
  1.  ;;^DD(1.5216,2,1,2,"DT")
  1.  ;;=2960903
  1.  ;;^DD(1.5216,2,9)
  1.  ;;=^
  1.  ;;^DD(1.5216,2,21,0)
  1.  ;;=^^1^1^2960926^
  1.  ;;^DD(1.5216,2,21,1,0)
  1.  ;;=IEN of table in SQLI_TABLE. Required.
  1.  ;;^DD(1.5216,2,"DT")
  1.  ;;=2960926
  1.  ;;^DD(1.5216,3,0)
  1.  ;;=E_TYPE^RS^C:Column;P:Primary key;F:Foreign key;^0;4^Q
  1.  ;;^DD(1.5216,3,.1)
  1.  ;;=Type
  1.  ;;^DD(1.5216,3,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5216,3,1,1,0)
  1.  ;;=1.5216^E
  1.  ;;^DD(1.5216,3,1,1,1)
  1.  ;;=S ^DMSQ("E","E",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5216,3,1,1,2)
  1.  ;;=K ^DMSQ("E","E",$E(X,1,30),DA)
  1.  ;;^DD(1.5216,3,1,1,"DT")
  1.  ;;=2960823
  1.  ;;^DD(1.5216,3,1,2,0)
  1.  ;;=1.5216^F^MUMPS
  1.  ;;^DD(1.5216,3,1,2,1)
  1.  ;;=S ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)=""
  1.  ;;^DD(1.5216,3,1,2,2)
  1.  ;;=K ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)
  1.  ;;^DD(1.5216,3,1,2,"%D",0)
  1.  ;;=^^1^1^2960827^^^^
  1.  ;;^DD(1.5216,3,1,2,"%D",1,0)
  1.  ;;=Table element by table by type
  1.  ;;^DD(1.5216,3,1,2,"DT")
  1.  ;;=2960827
  1.  ;;^DD(1.5216,3,9)
  1.  ;;=^
  1.  ;;^DD(1.5216,3,21,0)
  1.  ;;=^^1^1^2960926^
  1.  ;;^DD(1.5216,3,21,1,0)
  1.  ;;=C for column, P for primary key, or F for foreign key
  1.  ;;^DD(1.5216,3,"DT")
  1.  ;;=2960926
  1.  ;;^DD(1.5216,4,0)
  1.  ;;=E_COMMENT^F^^0;5^K:$L(X)>60!($L(X)<3) X
  1.  ;;^DD(1.5216,4,.1)
  1.  ;;=Comment
  1.  ;;^DD(1.5216,4,3)
  1.  ;;=Answer must be 3-60 characters in length.
  1.  ;;^DD(1.5216,4,9)
  1.  ;;=^
  1.  ;;^DD(1.5216,4,21,0)
  1.  ;;=^^1^1^2960926^
  1.  ;;^DD(1.5216,4,21,1,0)
  1.  ;;=A short description of the element
  1.  ;;^DD(1.5216,4,"DT")
  1.  ;;=2960926