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 |  Found Entries |  All
Print Page as PDF
Global: ^DMSQ("C"

Package: VA Fileman

Global: ^DMSQ("C"


Information

FileMan FileNo FileMan Filename Package
1.5217 SQLI_COLUMN VA Fileman

Description

Directly Accessed By Routines, Total: 7

Package Total Routines
VA Fileman 7 DMSQF    DMSQF1    DMSQF2    DMSQP3    DMSQP5    DMSQT    DMSQT1    

Pointed To By FileMan Files, Total: 3

Package Total FileMan Files
VA Fileman 3 SQLI_COLUMN(#1.5217)[8]    SQLI_FOREIGN_KEY(#1.5219)[2]    SQLI_PRIMARY_KEY(#1.5218)[1]    

Pointer To FileMan Files, Total: 3

Package Total FileMan Files
VA Fileman 3 SQLI_COLUMN(#1.5217)[8]    SQLI_TABLE_ELEMENT(#1.5216)[.01]    SQLI_OUTPUT_FORMAT(#1.5214)[16]    

Fields, Total: 17

Field # Name Loc Type Details
.01 C_TABLE_ELEMENT 0;1 POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216)
************************REQUIRED FIELD************************
SQLI_TABLE_ELEMENT(#1.5216)

  • LAST EDITED:  AUG 20, 1996
  • DESCRIPTION:  
    IEN of table element.
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5217^B
    1)= S ^DMSQ("C","B",$E(X,1,30),DA)=""
    2)= K ^DMSQ("C","B",$E(X,1,30),DA)
1 C_FILE 0;5 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>999999999.999999)!(X<1)!(X?.E1"."7N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 999999999.999999, 6 Decimal Digits
  • DESCRIPTION:  FileMan file (or subfile) ID, if column was derived from ^DD.
    NULL if column is generated by SQLI.
    WRITE AUTHORITY:  ^
2 C_WIDTH 0;2 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>22)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  AUG 20, 1996
  • HELP-PROMPT:  Type an integer between 1 and 999999999999999
  • DESCRIPTION:  
    Field width for display This field is estimated by SQLI from evidence in ^DD unless it's specified with J modifier.
    WRITE AUTHORITY:  ^
3 C_SCALE 0;3 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 9, 0 Decimal Digits
  • DESCRIPTION:  
    Number of decimal points to display on output (numeric only).  If scale is specified as 0, SQLI projects column as integer.
    WRITE AUTHORITY:  ^
4 C_FIELD 0;6 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999.9999999)!(X<.001)!(X?.E1"."8N.N) X
  • LAST EDITED:  MAR 11, 1997
  • HELP-PROMPT:  Type a Number between .001 and 9999999.9999999, 7 Decimal Digits
  • DESCRIPTION:  
    FileMan field ID from ^DD NULL unless column is derived directly from the data dictionary.
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5217^D^MUMPS
    1)= S ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)=""
    2)= K ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)
    Column by FileMan File number, by field number
5 C_NOT_NULL 0;7 SET
  • '0' FOR Not required;
  • '1' FOR Required;

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    When true (1) value is required, when false (0) not required.
    WRITE AUTHORITY:  ^
6 C_SECURE 0;8 SET
  • '0' FOR Not secure;
  • '1' FOR Secure;

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    If true, there is a security screen, else not.  When this flag is set, vendors should use DBS to retrieve data.
    WRITE AUTHORITY:  ^
7 C_VIRTUAL 0;9 SET
  • '0' FOR Base column;
  • '1' FOR Calculated value column;

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    If true, the value is computed.  Vendors should use DBS to get value.
    WRITE AUTHORITY:  ^
8 C_PARENT 0;10 POINTER TO SQLI_COLUMN FILE (#1.5217) SQLI_COLUMN(#1.5217)

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    Column whose physical global structure precedes this column.  Used to construct global root. Chain goes back to ^DIC.
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5217^C
    1)= S ^DMSQ("C","C",$E(X,1,30),DA)=""
    2)= K ^DMSQ("C","C",$E(X,1,30),DA)
    Column by parent column
9 C_GLOBAL 1;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  M global fragment which precedes this element
  • DESCRIPTION:  
    M global fragment between this column and parent column.  Contains node specifier for non-key columns. Key columns are constructed by SQLI and contain the multiple node specifier or ^DIC root.
    WRITE AUTHORITY:  ^
10 C_PIECE 0;11 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>99)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 99, 0 Decimal Digits
  • DESCRIPTION:  
    The piece address of the column in a data string.  If the piece address was of form E1,30, this value is null.
    WRITE AUTHORITY:  ^
11 C_EXTRACT_FROM 0;12 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 511, 0 Decimal Digits
  • DESCRIPTION:  
    First character to be extracted with $EXTRACT NULL unless specified by form E1,30.
    WRITE AUTHORITY:  ^
12 C_EXTRACT_THRU 0;13 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 511, 0 Decimal Digits
  • DESCRIPTION:  
    Last character to extract with $E
    WRITE AUTHORITY:  ^
13 C_COMPUTE_EXEC 2;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  M code to return value in {V}: machine generated
  • DESCRIPTION:  
    Computation execute uses $$GET1^DIQ to return code by default
  • EXECUTABLE HELP:  W ?5,"Enter code to return value in {V}"
    WRITE AUTHORITY:  ^
14 C_FM_EXEC 3;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Don't enter manually: machine generated.
  • DESCRIPTION:  
    Standard $$GET1^DIQ code to return value of pointer, variable pointer and computed values, or when security flag is set
  • EXECUTABLE HELP:  W ?5,"Don't enter this. It should be auto-generated."
    WRITE AUTHORITY:  ^
15 C_POINTER 4;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 06, 1996
  • HELP-PROMPT:  This is Standard MUMPS code.
  • DESCRIPTION:  
    Set translation string for SET, or global root for POINTER
    WRITE AUTHORITY:  ^
16 C_OUTPUT_FORMAT 0;4 POINTER TO SQLI_OUTPUT_FORMAT FILE (#1.5214) SQLI_OUTPUT_FORMAT(#1.5214)

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    IEN of default output format in SQLI_OUTPUT_FORMAT for this column Always present for SET, POINTER and VARIABLE-POINTER data types
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5217^E
    1)= S ^DMSQ("C","E",$E(X,1,30),DA)=""
    2)= K ^DMSQ("C","E",$E(X,1,30),DA)
    Column by output format
Info |  Desc |  Directly Accessed By Routines |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields |  Found Entries |  All