STANDARD DATA DICTIONARY #1.5211 -- SQLI_DATA_TYPE FILE                                                           3/24/25    PAGE 1
STORED IN ^DMSQ("DT",  *** NO DATA STORED YET ***   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                      (VERSION 22.2)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      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 


              DD ACCESS: ^
              WR ACCESS: ^
             DEL ACCESS: ^
           LAYGO ACCESS: ^

POINTED TO BY: DM_DATA_TYPE field (#1) of the SQLI_DOMAIN File (#1.5212) 
               KF_DATA_TYPE field (#1) of the SQLI_KEY_FORMAT File (#1.5213) 
               OF_DATA_TYPE field (#1) of the SQLI_OUTPUT_FORMAT File (#1.5214) 
               

CROSS
REFERENCED BY: D_NAME(B)



1.5211,.01    D_NAME                 0;1 FREE TEXT (Required)

              Data Type   
              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.5211,1      D_COMMENT              0;2 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:
                                Short description of the data type 

              WRITE AUTHORITY:  ^

1.5211,2      D_OUTPUT_STRATEGY      1;E1,245 MUMPS

              Output Strategy   
              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:  ^

1.5211,3      D_OUTPUT_FORMAT        0;3 POINTER TO SQLI_OUTPUT_FORMAT FILE (#1.5214)

              Output Format   
              LAST EDITED:      SEP 26, 1996 
              DESCRIPTION:
                                IEN of default output format in SQLI_OUTPUT_FORMAT 

              WRITE AUTHORITY:  ^


      FILES POINTED TO                      FIELDS

SQLI_OUTPUT_FORMAT (#1.5214)      D_OUTPUT_FORMAT (#3)



INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):