Global: ^DMSQ("DM"

Customize PDF page

Select the objects that you wish to see in the downloaded PDF

Info
Desc
Directly Accessed By Routines
Pointed To By FileMan Files
Pointer To FileMan Files
Fields
Found Entries

FileMan FileNo	FileMan Filename	Package
1.5212	SQLI_DOMAIN	VA Fileman

FileMan FileNo

FileMan Filename

Package

1.5212

SQLI_DOMAIN

VA Fileman

Description

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)

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

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

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


Name of FileMan domain Includes names of standard SQL data types. Must not be a keyword.
IEN of a standard data type in SQLI_DATA_TYPE. Required.
A short comment which describes the data type set
IEN of table in SQLI_TABLE if domain is of type PRIMARY_KEY Only primary and foreign keys have such domains.
Default display width. Overrides data type display width.
Default number of decimal places displayed for numbers.
Default output format for elements of this domain.  Used to provide text value of pointer chains, etc.
An M expression which returns the internal value of a base value.  Expression uses placeholder {B} to represent the base value
M code line which sets internal value, {I}, to some function of base value, {B}.
An M expression which returns the internal value of base value, {B}.
Code which when executed returns the base value of X
FileMan field type (F, N, D, DT, K, ...)

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

Customize PDF page

Package: VA Fileman

Global: ^DMSQ("DM"

Information

Description

Directly Accessed By Routines, Total: 9

Pointed To By FileMan Files, Total: 1

Pointer To FileMan Files, Total: 3

Fields, Total: 12