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("DM"

Package: VA FileMan

Global: ^DMSQ("DM"


Information

FileMan FileNo FileMan Filename Package
1.5212 SQLI_DOMAIN VA FileMan

Description

Directly Accessed By Routines, Total: 9

Package Total Routines
VA FileMan 9 DMSQD    DMSQF    DMSQF1    DMSQF2    DMSQP    DMSQP2    DMSQP3    DMSQP5
DMSQP6    

Pointed To By FileMan Files, Total: 1

Package Total FileMan Files
VA FileMan 1 SQLI_TABLE_ELEMENT(#1.5216)[1]    

Pointer To FileMan Files, Total: 3

Package Total FileMan Files
VA FileMan 3 SQLI_DATA_TYPE(#1.5211)[1]    SQLI_OUTPUT_FORMAT(#1.5214)[6]    SQLI_TABLE(#1.5215)[3]    

Fields, Total: 12

Field # Name Loc Type Details
.01 DM_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 an SQL identifier 3-30 characters in length.
  • DESCRIPTION:  
    Name of FileMan domain Includes names of standard SQL data types. Must not be a keyword.
  • EXECUTABLE HELP:  W ?5,"Must be a valid SQL identifier"
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5212^B
    1)= S ^DMSQ("DM","B",$E(X,1,30),DA)=""
    2)= K ^DMSQ("DM","B",$E(X,1,30),DA)
1 DM_DATA_TYPE 0;2 POINTER TO SQLI_DATA_TYPE FILE (#1.5211)
************************REQUIRED FIELD************************
SQLI_DATA_TYPE(#1.5211)

  • LAST EDITED:  SEP 09, 1996
  • DESCRIPTION:  
    IEN of a standard data type in SQLI_DATA_TYPE. Required.
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5212^E
    1)= S ^DMSQ("DM","E",$E(X,1,30),DA)=""
    2)= K ^DMSQ("DM","E",$E(X,1,30),DA)
    Domain by data type.
2 DM_COMMENT 0;3 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>60!($L(X)<3) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Answer must be 3-60 characters in length.
  • DESCRIPTION:  
    A short comment which describes the data type set
    WRITE AUTHORITY: ^
3 DM_TABLE 0;4 POINTER TO SQLI_TABLE FILE (#1.5215) SQLI_TABLE(#1.5215)

  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Enter only if domain is a table-id
  • DESCRIPTION:  
    IEN of table in SQLI_TABLE if domain is of type PRIMARY_KEY Only primary and foreign keys have such domains.
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5212^C
    1)= S ^DMSQ("DM","C",$E(X,1,30),DA)=""
    2)= K ^DMSQ("DM","C",$E(X,1,30),DA)
    Domain by table id
4 DM_WIDTH 0;5 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>255)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 255, 0 Decimal Digits
  • DESCRIPTION:  
    Default display width. Overrides data type display width.
    WRITE AUTHORITY: ^
5 DM_SCALE 0;6 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 0 and 9, 0 Decimal Digits
  • DESCRIPTION:  
    Default number of decimal places displayed for numbers.
    WRITE AUTHORITY: ^
6 DM_OUTPUT_FORMAT 0;7 POINTER TO SQLI_OUTPUT_FORMAT FILE (#1.5214) SQLI_OUTPUT_FORMAT(#1.5214)

  • LAST EDITED:  AUG 20, 1996
  • DESCRIPTION:  
    Default output format for elements of this domain. Used to provide text value of pointer chains, etc.
    WRITE AUTHORITY: ^
7 DM_INT_EXPR 1;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  This is a Standard M expression to format X for output
  • DESCRIPTION:  
    An M expression which returns the internal value of a base value. Expression uses placeholder {B} to represent the base value
    WRITE AUTHORITY: ^
8 DM_INT_EXEC 2;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  This is Standard MUMPS code to format X for input
  • DESCRIPTION:  
    M code line which sets internal value, {I}, to some function of base value, {B}.
    WRITE AUTHORITY: ^
9 DM_BASE_EXPR 3;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  This is a Standard M expression to format X in internal form.
  • DESCRIPTION:  
    An M expression which returns the internal value of base value, {B}.
    WRITE AUTHORITY: ^
10 DM_BASE_EXEC 4;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  AUG 20, 1996
  • HELP-PROMPT:  This is Standard MUMPS code.
  • DESCRIPTION:  
    Code which when executed returns the base value of X
    WRITE AUTHORITY: ^
11 DM_FILEMAN_FIELD_TYPE 0;8 SET
  • 'F' FOR FREE TEXT;
  • 'N' FOR NUMERIC;
  • 'P' FOR POINTER;
  • 'D' FOR DATE;
  • 'W' FOR WORD-PROCESSING;
  • 'K' FOR MUMPS;
  • 'B' FOR BOOLEAN;
  • 'S' FOR SET-OF-CODES;
  • 'V' FOR VARIABLE POINTER;

  • LAST EDITED:  FEB 25, 1997
  • DESCRIPTION:  
    FileMan field type (F, N, D, DT, K, ...)
  • TECHNICAL DESCR:  
    A value in this field indicates that the domain is derived from a FileMan-specific field type. It is intended to signal vendors that a proprietary function may be required to implement the domain.
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5212^D
    1)= S ^DMSQ("DM","D",$E(X,1,30),DA)=""
    2)= K ^DMSQ("DM","D",$E(X,1,30),DA)
    Domain by FileMan type
Info |  Desc |  Directly Accessed By Routines |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields  | All