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

DINIT2B7.m

Go to the documentation of this file. 
  1. DINIT2B7 ;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 ^DINIT2B8
  1. Q Q
  1.  ;;^DIC(1.5215,0,"GL")
  1.  ;;=^DMSQ("T",
  1.  ;;^DIC("B","SQLI_TABLE",1.5215)
  1.  ;;=
  1.  ;;^DIC(1.5215,"%D",0)
  1.  ;;=^^6^6^2970806^^^
  1.  ;;^DIC(1.5215,"%D",1,0)
  1.  ;;=Descriptor of a set of table elements: Includes name and file no.
  1.  ;;^DIC(1.5215,"%D",2,0)
  1.  ;;=(See SQLI_TABLE_ELEMENTS). Each ^DD(DA) represents a table in a relational
  1.  ;;^DIC(1.5215,"%D",3,0)
  1.  ;;=model of FileMan. Further, each index represents a table. 
  1.  ;;^DIC(1.5215,"%D",4,0)
  1.  ;;= 
  1.  ;;^DIC(1.5215,"%D",5,0)
  1.  ;;=Each schema contains multiple tables. Each table contains just one primary
  1.  ;;^DIC(1.5215,"%D",6,0)
  1.  ;;=key, but multiple columns, foreign keys and indicies.
  1.  ;;^DD(1.5215,0)
  1.  ;;=FIELD^^8^9
  1.  ;;^DD(1.5215,0,"DDA")
  1.  ;;=N
  1.  ;;^DD(1.5215,0,"DT")
  1.  ;;=2960913
  1.  ;;^DD(1.5215,0,"IX","B",1.5215,.01)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"IX","C",1.5215,6)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"IX","D",1.5215,8)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"IX","E",1.5215,3)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"NM","SQLI_TABLE")
  1.  ;;=
  1.  ;;^DD(1.5215,0,"PT",1.5212,3)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"PT",1.5215,3)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"PT",1.5216,2)
  1.  ;;=
  1.  ;;^DD(1.5215,0,"VRPK")
  1.  ;;=DI
  1.  ;;^DD(1.5215,.01,0)
  1.  ;;=T_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
  1.  ;;^DD(1.5215,.01,.1)
  1.  ;;=Table
  1.  ;;^DD(1.5215,.01,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5215,.01,1,1,0)
  1.  ;;=1.5215^B
  1.  ;;^DD(1.5215,.01,1,1,1)
  1.  ;;=S ^DMSQ("T","B",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5215,.01,1,1,2)
  1.  ;;=K ^DMSQ("T","B",$E(X,1,30),DA)
  1.  ;;^DD(1.5215,.01,3)
  1.  ;;=Answer must be 3-30 characters in length.
  1.  ;;^DD(1.5215,.01,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,.01,21,0)
  1.  ;;=^^1^1^2960926^
  1.  ;;^DD(1.5215,.01,21,1,0)
  1.  ;;=Table name must be a valid SQL identifier, unique by schema
  1.  ;;^DD(1.5215,.01,"DT")
  1.  ;;=2960820
  1.  ;;^DD(1.5215,1,0)
  1.  ;;=T_SCHEMA^RP1.521^DMSQ("S",^0;2^Q
  1.  ;;^DD(1.5215,1,.1)
  1.  ;;=Schema
  1.  ;;^DD(1.5215,1,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,1,21,0)
  1.  ;;=^^1^1^2960926^^
  1.  ;;^DD(1.5215,1,21,1,0)
  1.  ;;=IEN in SQLI_SCHEMA of the schema to which this table belongs.
  1.  ;;^DD(1.5215,1,"DT")
  1.  ;;=2960913
  1.  ;;^DD(1.5215,2,0)
  1.  ;;=T_COMMENT^F^^0;3^K:$L(X)>70!($L(X)<3) X
  1.  ;;^DD(1.5215,2,.1)
  1.  ;;=Description
  1.  ;;^DD(1.5215,2,3)
  1.  ;;=Answer must be 3-70 characters in length.
  1.  ;;^DD(1.5215,2,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,2,21,0)
  1.  ;;=^^1^1^2960926^^
  1.  ;;^DD(1.5215,2,21,1,0)
  1.  ;;=A short description of the table
  1.  ;;^DD(1.5215,2,"DT")
  1.  ;;=2960913
  1.  ;;^DD(1.5215,3,0)
  1.  ;;=T_MASTER_TABLE^P1.5215'^DMSQ("T",^0;4^Q
  1.  ;;^DD(1.5215,3,.1)
  1.  ;;=Master Table
  1.  ;;^DD(1.5215,3,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5215,3,1,1,0)
  1.  ;;=1.5215^E
  1.  ;;^DD(1.5215,3,1,1,1)
  1.  ;;=S ^DMSQ("T","E",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5215,3,1,1,2)
  1.  ;;=K ^DMSQ("T","E",$E(X,1,30),DA)
  1.  ;;^DD(1.5215,3,1,1,"%D",0)
  1.  ;;=^^1^1^2960904^
  1.  ;;^DD(1.5215,3,1,1,"%D",1,0)
  1.  ;;=Table by master table
  1.  ;;^DD(1.5215,3,1,1,"DT")
  1.  ;;=2960904
  1.  ;;^DD(1.5215,3,3)
  1.  ;;=Enter only if this table is an index
  1.  ;;^DD(1.5215,3,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,3,21,0)
  1.  ;;=^^1^1^2960926^^^
  1.  ;;^DD(1.5215,3,21,1,0)
  1.  ;;=The table of which this table is an index. (Only index tables)
  1.  ;;^DD(1.5215,3,23,0)
  1.  ;;=^^1^1^2960926^^
  1.  ;;^DD(1.5215,3,23,1,0)
  1.  ;;=In SQL, and in the relational model, an index is just a table.
  1.  ;;^DD(1.5215,3,"DT")
  1.  ;;=2960913
  1.  ;;^DD(1.5215,4,0)
  1.  ;;=T_VERSION_FM^NJ9,0^^0;5^K:+X'=X!(X>999999999)!(X<1)!(X?.E1"."1N.N) X
  1.  ;;^DD(1.5215,4,.1)
  1.  ;;=Version
  1.  ;;^DD(1.5215,4,3)
  1.  ;;=Type a Number between 1 and 999999999, 0 Decimal Digits
  1.  ;;^DD(1.5215,4,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,4,21,0)
  1.  ;;=^^1^1^2960926^^
  1.  ;;^DD(1.5215,4,21,1,0)
  1.  ;;=The version number is updated by FileMan when ^DD or ^DIC changes.
  1.  ;;^DD(1.5215,4,"DT")
  1.  ;;=2960926
  1.  ;;^DD(1.5215,5,0)
  1.  ;;=T_ROW_COUNT^NJ9,0^^0;6^K:+X'=X!(X>999999999)!(X<0)!(X?.E1"."1N.N) X
  1.  ;;^DD(1.5215,5,.1)
  1.  ;;=Row Count
  1.  ;;^DD(1.5215,5,3)
  1.  ;;=Type a Number between 0 and 999999999, 0 Decimal Digits
  1.  ;;^DD(1.5215,5,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,5,21,0)
  1.  ;;=^^1^1^2960926^^
  1.  ;;^DD(1.5215,5,21,1,0)
  1.  ;;=This field should contain an estimate of the number of rows in the table
  1.  ;;^DD(1.5215,5,"DT")
  1.  ;;=2960926
  1.  ;;^DD(1.5215,6,0)
  1.  ;;=T_FILE^RNJ19,9O^^0;7^K:+X'=X!(X>999999999)!(X<0)!(X?.E1"."10N.N) X
  1.  ;;^DD(1.5215,6,.1)
  1.  ;;=Source File
  1.  ;;^DD(1.5215,6,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5215,6,1,1,0)
  1.  ;;=1.5215^C
  1.  ;;^DD(1.5215,6,1,1,1)
  1.  ;;=S ^DMSQ("T","C",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5215,6,1,1,2)
  1.  ;;=K ^DMSQ("T","C",$E(X,1,30),DA)
  1.  ;;^DD(1.5215,6,1,1,"%D",0)
  1.  ;;=^^1^1^2960902^^
  1.  ;;^DD(1.5215,6,1,1,"%D",1,0)
  1.  ;;=Table by source file index
  1.  ;;^DD(1.5215,6,1,1,"DT")
  1.  ;;=2960822
  1.  ;;^DD(1.5215,6,2)
  1.  ;;=S Y(0)=Y S Y=$S('Y:"",$D(^DIC(+Y)):$P(^(+Y,0),U),1:$O(^DD(+Y,0,"NM","")))
  1.  ;;^DD(1.5215,6,2.1)
  1.  ;;=S Y=$S('Y:"",$D(^DIC(+Y)):$P(^(+Y,0),U),1:$O(^DD(+Y,0,"NM","")))
  1.  ;;^DD(1.5215,6,3)
  1.  ;;=Type a Number between 0 and 999999999, 9 Decimal Digits
  1.  ;;^DD(1.5215,6,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,6,21,0)
  1.  ;;=^^1^1^2960926^^^
  1.  ;;^DD(1.5215,6,21,1,0)
  1.  ;;=FileMan file number from which table is derived.
  1.  ;;^DD(1.5215,6,23,0)
  1.  ;;=^^1^1^2960926^^
  1.  ;;^DD(1.5215,6,23,1,0)
  1.  ;;=This may be a subfile number
  1.  ;;^DD(1.5215,6,"DT")
  1.  ;;=2960908
  1.  ;;^DD(1.5215,7,0)
  1.  ;;=T_UPDATE^D^^0;8^S %DT="EX" D ^%DT S X=Y K:Y<1 X
  1.  ;;^DD(1.5215,7,.1)
  1.  ;;=Last Updated
  1.  ;;^DD(1.5215,7,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,7,21,0)
  1.  ;;=^^1^1^2960926^
  1.  ;;^DD(1.5215,7,21,1,0)
  1.  ;;=Date last updated.
  1.  ;;^DD(1.5215,7,"DT")
  1.  ;;=2960821
  1.  ;;^DD(1.5215,8,0)
  1.  ;;=T_GLOBAL^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
  1.  ;;^DD(1.5215,8,.1)
  1.  ;;=Global Root
  1.  ;;^DD(1.5215,8,1,0)
  1.  ;;=^.1
  1.  ;;^DD(1.5215,8,1,1,0)
  1.  ;;=1.5215^D
  1.  ;;^DD(1.5215,8,1,1,1)
  1.  ;;=S ^DMSQ("T","D",$E(X,1,30),DA)=""
  1.  ;;^DD(1.5215,8,1,1,2)
  1.  ;;=K ^DMSQ("T","D",$E(X,1,30),DA)
  1.  ;;^DD(1.5215,8,1,1,"%D",0)
  1.  ;;=^^1^1^2960822^
  1.  ;;^DD(1.5215,8,1,1,"%D",1,0)
  1.  ;;=Table by global name. Used for structural study.
  1.  ;;^DD(1.5215,8,1,1,"DT")
  1.  ;;=2960822
  1.  ;;^DD(1.5215,8,3)
  1.  ;;=A valid M global variable name using {K} for subscripts
  1.  ;;^DD(1.5215,8,9)
  1.  ;;=^
  1.  ;;^DD(1.5215,8,21,0)
  1.  ;;=^^2^2^2960926^^^^
  1.  ;;^DD(1.5215,8,21,1,0)
  1.  ;;=Global variable name. {K} stands for a subscript
  1.  ;;^DD(1.5215,8,21,2,0)
  1.  ;;=E.g.: ^DIC(9.4,{K},3,{K},4,{K})
  1.  ;;^DD(1.5215,8,23,0)
  1.  ;;=^^1^1^2960926^^^
  1.  ;;^DD(1.5215,8,23,1,0)
  1.  ;;=Used to piece out global fragments for columns
  1.  ;;^DD(1.5215,8,"DT")
  1.  ;;=2960926