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

DINIT2B9.m

Go to the documentation of this file.
  1. DINIT2B9 ;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 ^DINIT2BA
  1. Q Q
  1. ;;^DIC(1.5217,0,"GL")
  1. ;;=^DMSQ("C",
  1. ;;^DIC("B","SQLI_COLUMN",1.5217)
  1. ;;=
  1. ;;^DIC(1.5217,"%D",0)
  1. ;;=^^6^6^2970806^^
  1. ;;^DIC(1.5217,"%D",1,0)
  1. ;;=A set of formatting and physical structure specifications.
  1. ;;^DIC(1.5217,"%D",2,0)
  1. ;;=Each column specification has a column type table element
  1. ;;^DIC(1.5217,"%D",3,0)
  1. ;;=(SQLI_TABLE_ELEMENT) which contains the relational specifications, name
  1. ;;^DIC(1.5217,"%D",4,0)
  1. ;;=and domain. The column specification contains those attributes required
  1. ;;^DIC(1.5217,"%D",5,0)
  1. ;;=to locate the value in the global structure, and to project the value to
  1. ;;^DIC(1.5217,"%D",6,0)
  1. ;;=the user.
  1. ;;^DD(1.5217,0)
  1. ;;=FIELD^^16^17
  1. ;;^DD(1.5217,0,"DT")
  1. ;;=2970311
  1. ;;^DD(1.5217,0,"IX","B",1.5217,.01)
  1. ;;=
  1. ;;^DD(1.5217,0,"IX","C",1.5217,8)
  1. ;;=
  1. ;;^DD(1.5217,0,"IX","D",1.5217,4)
  1. ;;=
  1. ;;^DD(1.5217,0,"IX","E",1.5217,16)
  1. ;;=
  1. ;;^DD(1.5217,0,"NM","SQLI_COLUMN")
  1. ;;=
  1. ;;^DD(1.5217,0,"PT",1.5217,8)
  1. ;;=
  1. ;;^DD(1.5217,0,"PT",1.5218,1)
  1. ;;=
  1. ;;^DD(1.5217,0,"PT",1.5219,2)
  1. ;;=
  1. ;;^DD(1.5217,0,"VRPK")
  1. ;;=DI
  1. ;;^DD(1.5217,.01,0)
  1. ;;=C_TABLE_ELEMENT^RP1.5216'^DMSQ("E",^0;1^Q
  1. ;;^DD(1.5217,.01,.1)
  1. ;;=Table Element
  1. ;;^DD(1.5217,.01,1,0)
  1. ;;=^.1
  1. ;;^DD(1.5217,.01,1,1,0)
  1. ;;=1.5217^B
  1. ;;^DD(1.5217,.01,1,1,1)
  1. ;;=S ^DMSQ("C","B",$E(X,1,30),DA)=""
  1. ;;^DD(1.5217,.01,1,1,2)
  1. ;;=K ^DMSQ("C","B",$E(X,1,30),DA)
  1. ;;^DD(1.5217,.01,3)
  1. ;;=
  1. ;;^DD(1.5217,.01,9)
  1. ;;=^
  1. ;;^DD(1.5217,.01,21,0)
  1. ;;=^^1^1^2960926^^
  1. ;;^DD(1.5217,.01,21,1,0)
  1. ;;=IEN of table element.
  1. ;;^DD(1.5217,.01,"DT")
  1. ;;=2960820
  1. ;;^DD(1.5217,1,0)
  1. ;;=C_FILE^NJ16,6^^0;5^K:+X'=X!(X>999999999.999999)!(X<1)!(X?.E1"."7N.N) X
  1. ;;^DD(1.5217,1,.1)
  1. ;;=File ID
  1. ;;^DD(1.5217,1,3)
  1. ;;=Type a Number between 1 and 999999999.999999, 6 Decimal Digits
  1. ;;^DD(1.5217,1,9)
  1. ;;=^
  1. ;;^DD(1.5217,1,21,0)
  1. ;;=^^2^2^2960926^
  1. ;;^DD(1.5217,1,21,1,0)
  1. ;;=FileMan file (or subfile) ID, if column was derived from ^DD.
  1. ;;^DD(1.5217,1,21,2,0)
  1. ;;= NULL if column is generated by SQLI.
  1. ;;^DD(1.5217,1,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,2,0)
  1. ;;=C_WIDTH^NJ2,0^^0;2^K:+X'=X!(X>22)!(X<1)!(X?.E1"."1N.N) X
  1. ;;^DD(1.5217,2,.1)
  1. ;;=Width
  1. ;;^DD(1.5217,2,3)
  1. ;;=Type an integer between 1 and 999999999999999
  1. ;;^DD(1.5217,2,9)
  1. ;;=^
  1. ;;^DD(1.5217,2,21,0)
  1. ;;=^^3^3^2960926^
  1. ;;^DD(1.5217,2,21,1,0)
  1. ;;=Field width for display
  1. ;;^DD(1.5217,2,21,2,0)
  1. ;;=This field is estimated by SQLI from evidence in ^DD unless it's specified
  1. ;;^DD(1.5217,2,21,3,0)
  1. ;;=with J modifier.
  1. ;;^DD(1.5217,2,"DT")
  1. ;;=2960820
  1. ;;^DD(1.5217,3,0)
  1. ;;=C_SCALE^NJ1,0^^0;3^K:+X'=X!(X>9)!(X<1)!(X?.E1"."1N.N) X
  1. ;;^DD(1.5217,3,.1)
  1. ;;=Dec. Pt.
  1. ;;^DD(1.5217,3,3)
  1. ;;=Type a Number between 1 and 9, 0 Decimal Digits
  1. ;;^DD(1.5217,3,9)
  1. ;;=^
  1. ;;^DD(1.5217,3,21,0)
  1. ;;=^^2^2^2960926^
  1. ;;^DD(1.5217,3,21,1,0)
  1. ;;=Number of decimal points to display on output (numeric only).
  1. ;;^DD(1.5217,3,21,2,0)
  1. ;;=If scale is specified as 0, SQLI projects column as integer.
  1. ;;^DD(1.5217,3,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,4,0)
  1. ;;=C_FIELD^NJ15,7^^0;6^K:+X'=X!(X>9999999.9999999)!(X<.001)!(X?.E1"."8N.N) X
  1. ;;^DD(1.5217,4,1,0)
  1. ;;=^.1
  1. ;;^DD(1.5217,4,1,1,0)
  1. ;;=1.5217^D^MUMPS
  1. ;;^DD(1.5217,4,1,1,1)
  1. ;;=S ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)=""
  1. ;;^DD(1.5217,4,1,1,2)
  1. ;;=K ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)
  1. ;;^DD(1.5217,4,1,1,"%D",0)
  1. ;;=^^1^1^2960827^
  1. ;;^DD(1.5217,4,1,1,"%D",1,0)
  1. ;;=Column by FileMan File number, by field number
  1. ;;^DD(1.5217,4,1,1,"DT")
  1. ;;=2960827
  1. ;;^DD(1.5217,4,3)
  1. ;;=Type a Number between .001 and 9999999.9999999, 7 Decimal Digits
  1. ;;^DD(1.5217,4,9)
  1. ;;=^
  1. ;;^DD(1.5217,4,21,0)
  1. ;;=^^2^2^2970311^^^
  1. ;;^DD(1.5217,4,21,1,0)
  1. ;;=FileMan field ID from ^DD
  1. ;;^DD(1.5217,4,21,2,0)
  1. ;;=NULL unless column is derived directly from the data dictionary.
  1. ;;^DD(1.5217,4,"DT")
  1. ;;=2970311
  1. ;;^DD(1.5217,5,0)
  1. ;;=C_NOT_NULL^S^0:Not required;1:Required;^0;7^Q
  1. ;;^DD(1.5217,5,.1)
  1. ;;=Req.
  1. ;;^DD(1.5217,5,9)
  1. ;;=^
  1. ;;^DD(1.5217,5,21,0)
  1. ;;=^^1^1^2960926^
  1. ;;^DD(1.5217,5,21,1,0)
  1. ;;=When true (1) value is required, when false (0) not required.
  1. ;;^DD(1.5217,5,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,6,0)
  1. ;;=C_SECURE^S^0:Not secure;1:Secure;^0;8^Q
  1. ;;^DD(1.5217,6,.1)
  1. ;;=Secure
  1. ;;^DD(1.5217,6,9)
  1. ;;=^
  1. ;;^DD(1.5217,6,21,0)
  1. ;;=^^2^2^2960926^
  1. ;;^DD(1.5217,6,21,1,0)
  1. ;;=If true, there is a security screen, else not.
  1. ;;^DD(1.5217,6,21,2,0)
  1. ;;=When this flag is set, vendors should use DBS to retrieve data.
  1. ;;^DD(1.5217,6,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,7,0)
  1. ;;=C_VIRTUAL^S^0:Base column;1:Calculated value column;^0;9^Q
  1. ;;^DD(1.5217,7,.1)
  1. ;;=Virtual
  1. ;;^DD(1.5217,7,9)
  1. ;;=^
  1. ;;^DD(1.5217,7,21,0)
  1. ;;=^^2^2^2960926^
  1. ;;^DD(1.5217,7,21,1,0)
  1. ;;=If true, the value is computed.
  1. ;;^DD(1.5217,7,21,2,0)
  1. ;;=Vendors should use DBS to get value.
  1. ;;^DD(1.5217,7,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,8,0)
  1. ;;=C_PARENT^P1.5217'^DMSQ("C",^0;10^Q
  1. ;;^DD(1.5217,8,.1)
  1. ;;=Parent Column
  1. ;;^DD(1.5217,8,1,0)
  1. ;;=^.1
  1. ;;^DD(1.5217,8,1,1,0)
  1. ;;=1.5217^C
  1. ;;^DD(1.5217,8,1,1,1)
  1. ;;=S ^DMSQ("C","C",$E(X,1,30),DA)=""
  1. ;;^DD(1.5217,8,1,1,2)
  1. ;;=K ^DMSQ("C","C",$E(X,1,30),DA)
  1. ;;^DD(1.5217,8,1,1,"%D",0)
  1. ;;=^^1^1^2960823^
  1. ;;^DD(1.5217,8,1,1,"%D",1,0)
  1. ;;=Column by parent column
  1. ;;^DD(1.5217,8,1,1,"DT")
  1. ;;=2960823
  1. ;;^DD(1.5217,8,9)
  1. ;;=^
  1. ;;^DD(1.5217,8,21,0)
  1. ;;=^^2^2^2960926^
  1. ;;^DD(1.5217,8,21,1,0)
  1. ;;=Column whose physical global structure precedes this column.
  1. ;;^DD(1.5217,8,21,2,0)
  1. ;;=Used to construct global root. Chain goes back to ^DIC.
  1. ;;^DD(1.5217,8,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,9,0)
  1. ;;=C_GLOBAL^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
  1. ;;^DD(1.5217,9,.1)
  1. ;;=Global
  1. ;;^DD(1.5217,9,3)
  1. ;;=M global fragment which precedes this element
  1. ;;^DD(1.5217,9,9)
  1. ;;=^
  1. ;;^DD(1.5217,9,21,0)
  1. ;;=^^3^3^2960926^
  1. ;;^DD(1.5217,9,21,1,0)
  1. ;;=M global fragment between this column and parent column.
  1. ;;^DD(1.5217,9,21,2,0)
  1. ;;=Contains node specifier for non-key columns. Key columns are constructed
  1. ;;^DD(1.5217,9,21,3,0)
  1. ;;=by SQLI and contain the multiple node specifier or ^DIC root.
  1. ;;^DD(1.5217,9,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,10,0)
  1. ;;=C_PIECE^NJ2,0^^0;11^K:+X'=X!(X>99)!(X<1)!(X?.E1"."1N.N) X
  1. ;;^DD(1.5217,10,.1)
  1. ;;=Piece
  1. ;;^DD(1.5217,10,3)
  1. ;;=Type a Number between 1 and 99, 0 Decimal Digits
  1. ;;^DD(1.5217,10,9)
  1. ;;=^
  1. ;;^DD(1.5217,10,21,0)
  1. ;;=^^2^2^2960926^
  1. ;;^DD(1.5217,10,21,1,0)
  1. ;;=The piece address of the column in a data string.
  1. ;;^DD(1.5217,10,21,2,0)
  1. ;;=If the piece address was of form E1,30, this value is null.
  1. ;;^DD(1.5217,10,"DT")
  1. ;;=2960926
  1. ;;^DD(1.5217,11,0)
  1. ;;=C_EXTRACT_FROM^NJ3,0^^0;12^K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X