STANDARD DATA DICTIONARY #1.5212 -- SQLI_DOMAIN FILE 3/24/25 PAGE 1
STORED IN ^DMSQ("DM", *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 22.2)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
The set from which all objects of that domain must be drawn. In SQLI, all table elements (SQLI_TABLE_ELEMENT) have a domain which
restricts them to their domain set. For each data type there is a domain of the same name, representing the same set. Other domains
have different set membership restrictions.
Each domain has a data type, which determines the rules for comparing values from different domains, and the operators which may be
used on them.
The PRIMARY_KEY data type and domain is unique to SQLI. It is used to relate primary keys to foreign keys unambiguously (see
SQLI_TABLE_ELEMENT)
DD ACCESS: ^
WR ACCESS: ^
DEL ACCESS: ^
LAYGO ACCESS: ^
POINTED TO BY: E_DOMAIN field (#1) of the SQLI_TABLE_ELEMENT File (#1.5216)
CROSS
REFERENCED BY: DM_NAME(B), DM_TABLE(C), DM_FILEMAN_FIELD_TYPE(D), DM_DATA_TYPE(E)
1.5212,.01 DM_NAME 0;1 FREE TEXT (Required)
Domain
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.5212,1 DM_DATA_TYPE 0;2 POINTER TO SQLI_DATA_TYPE FILE (#1.5211) (Required)
Data Type
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.
1.5212,2 DM_COMMENT 0;3 FREE TEXT
Comment
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: ^
1.5212,3 DM_TABLE 0;4 POINTER TO SQLI_TABLE FILE (#1.5215)
Table
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
1.5212,4 DM_WIDTH 0;5 NUMBER
Width
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: ^
1.5212,5 DM_SCALE 0;6 NUMBER
Scale
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: ^
1.5212,6 DM_OUTPUT_FORMAT 0;7 POINTER TO SQLI_OUTPUT_FORMAT FILE (#1.5214)
Output Format
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: ^
1.5212,7 DM_INT_EXPR 1;E1,245 MUMPS
Base to Internal Expression
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: ^
1.5212,8 DM_INT_EXEC 2;E1,245 MUMPS
Base to Internal Execute
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: ^
1.5212,9 DM_BASE_EXPR 3;E1,245 MUMPS
Internal to Base Expression
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: ^
1.5212,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: ^
1.5212,11 DM_FILEMAN_FIELD_TYPE 0;8 SET
FT
'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
FILES POINTED TO FIELDS
SQLI_DATA_TYPE (#1.5211) DM_DATA_TYPE (#1)
SQLI_OUTPUT_FORMAT (#1.5214) DM_OUTPUT_FORMAT (#6)
SQLI_TABLE (#1.5215) DM_TABLE (#3)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):