Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Directly Accessed By Routines |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields  | All
Print Page as PDF
Global: ^DMSQ("T"

Package: VA FileMan

Global: ^DMSQ("T"


Information

FileMan FileNo FileMan Filename Package
1.5215 SQLI_TABLE VA FileMan

Description

Directly Accessed By Routines, Total: 14

Package Total Routines
VA FileMan 14 DMSQ    DMSQD    DMSQF    DMSQF1    DMSQF2    DMSQP    DMSQP2    DMSQP3
DMSQP5    DMSQP6    DMSQS    DMSQT    DMSQT1    DMSQU    

Pointed To By FileMan Files, Total: 3

Package Total FileMan Files
VA FileMan 3 SQLI_DOMAIN(#1.5212)[3]    SQLI_TABLE_ELEMENT(#1.5216)[2]    SQLI_TABLE(#1.5215)[3]    

Pointer To FileMan Files, Total: 2

Package Total FileMan Files
VA FileMan 2 SQLI_SCHEMA(#1.521)[1]    SQLI_TABLE(#1.5215)[3]    

Fields, Total: 9

Field # Name Loc Type Details
.01 T_NAME 0;1 FREE TEXT
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
  • LAST EDITED:  AUG 20, 1996
  • HELP-PROMPT:  Answer must be 3-30 characters in length.
  • DESCRIPTION:  
    Table name must be a valid SQL identifier, unique by schema
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5215^B
    1)= S ^DMSQ("T","B",$E(X,1,30),DA)=""
    2)= K ^DMSQ("T","B",$E(X,1,30),DA)
1 T_SCHEMA 0;2 POINTER TO SQLI_SCHEMA FILE (#1.521)
************************REQUIRED FIELD************************
SQLI_SCHEMA(#1.521)

  • LAST EDITED:  SEP 13, 1996
  • DESCRIPTION:  
    IEN in SQLI_SCHEMA of the schema to which this table belongs.
    WRITE AUTHORITY: ^
2 T_COMMENT 0;3 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>70!($L(X)<3) X
  • LAST EDITED:  SEP 13, 1996
  • HELP-PROMPT:  Answer must be 3-70 characters in length.
  • DESCRIPTION:  
    A short description of the table
    WRITE AUTHORITY: ^
3 T_MASTER_TABLE 0;4 POINTER TO SQLI_TABLE FILE (#1.5215) SQLI_TABLE(#1.5215)

  • LAST EDITED:  SEP 13, 1996
  • HELP-PROMPT:  Enter only if this table is an index
  • DESCRIPTION:  
    The table of which this table is an index. (Only index tables)
  • TECHNICAL DESCR:  
    In SQL, and in the relational model, an index is just a table.
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5215^E
    1)= S ^DMSQ("T","E",$E(X,1,30),DA)=""
    2)= K ^DMSQ("T","E",$E(X,1,30),DA)
    Table by master table
4 T_VERSION_FM 0;5 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>999999999)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 999999999, 0 Decimal Digits
  • DESCRIPTION:  
    The version number is updated by FileMan when ^DD or ^DIC changes.
    WRITE AUTHORITY: ^
5 T_ROW_COUNT 0;6 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>999999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 0 and 999999999, 0 Decimal Digits
  • DESCRIPTION:  
    This field should contain an estimate of the number of rows in the table
    WRITE AUTHORITY: ^
6 T_FILE 0;7 NUMBER
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:+X'=X!(X>999999999)!(X<0)!(X?.E1"."10N.N) X
  • OUTPUT TRANSFORM:  S Y=$S('Y:"",$D(^DIC(+Y)):$P(^(+Y,0),U),1:$O(^DD(+Y,0,"NM","")))
  • LAST EDITED:  SEP 08, 1996
  • HELP-PROMPT:  Type a Number between 0 and 999999999, 9 Decimal Digits
  • DESCRIPTION:  
    FileMan file number from which table is derived.
  • TECHNICAL DESCR:  
    This may be a subfile number
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5215^C
    1)= S ^DMSQ("T","C",$E(X,1,30),DA)=""
    2)= K ^DMSQ("T","C",$E(X,1,30),DA)
    Table by source file index
7 T_UPDATE 0;8 DATE

  • INPUT TRANSFORM:  S %DT="EX" D ^%DT S X=Y K:Y<1 X
  • LAST EDITED:  AUG 21, 1996
  • DESCRIPTION:  
    Date last updated.
    WRITE AUTHORITY: ^
8 T_GLOBAL 1;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  A valid M global variable name using {K} for subscripts
  • DESCRIPTION:  
    Global variable name. {K} stands for a subscript E.g.: ^DIC(9.4,{K},3,{K},4,{K})
  • TECHNICAL DESCR:  
    Used to piece out global fragments for columns
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5215^D
    1)= S ^DMSQ("T","D",$E(X,1,30),DA)=""
    2)= K ^DMSQ("T","D",$E(X,1,30),DA)
    Table by global name. Used for structural study.
Info |  Desc |  Directly Accessed By Routines |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields  | All