Global: ^DMSQ("DT"

FileMan FileNo	FileMan Filename	Package
1.5211	SQLI_DATA_TYPE	VA Fileman

FileMan FileNo

FileMan Filename

Package

1.5211

SQLI_DATA_TYPE

A set of values from which all domains of that type may be drawn. PRIMARY_KEY - the set of all primary keys (in SQLI_TABLE_ELEMENT, type P) CHARACTER - the set of all character strings of length less than 256 INTEGER - the set of all cardinal numbers NUMERIC - the set of all real numbers DATE - the set of all date valued tokens TIME - the set of all time valued tokens MOMENT - the set of all tokens which have both a date and a time value BOOLEAN - the set of all tokens which evaluate to true or false only MEMO - the set of all character strings of length > 255

Package	Total	Routines
VA Fileman	1	DMSQD

Package

Total

Routines

DMSQD

Package	Total	FileMan Files
VA Fileman	3	SQLI_DOMAIN(#1.5212)[1] SQLI_KEY_FORMAT(#1.5213)[1] SQLI_OUTPUT_FORMAT(#1.5214)[1]

Package

Total

FileMan Files

Package	Total	FileMan Files
VA Fileman	1	SQLI_OUTPUT_FORMAT(#1.5214)[3]

Package

Total

FileMan Files

Fields, Total: 4

Field #	Name	Loc	Type	Details
.01	D_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: ODBC Standard data type corresponding to FileMan domains EXECUTABLE HELP: `W ?5,"Must be a valid SQL identifier"` WRITE AUTHORITY: ^ CROSS-REFERENCE: `1.5211^B` 1)= S ^DMSQ("DT","B",$E(X,1,30),DA)="" 2)= K ^DMSQ("DT","B",$E(X,1,30),DA)
1	D_COMMENT	0;2	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: Short description of the data type WRITE AUTHORITY: ^
2	D_OUTPUT_STRATEGY	1;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 output.` DESCRIPTION: M code which returns external value, {E} of base value, {B}. WRITE AUTHORITY: ^
3	D_OUTPUT_FORMAT	0;3	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 WRITE AUTHORITY: ^