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

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
Strategies for converting base values to external values.  In FileMan they are used to convert references to pointers to their text
values. They are also used for the SET OF CODES type.  
 
SQLI projects pointer and set of codes as calls to $$GET1^DIQ, variable pointer into calls to $$EXTERNAL^DILFD.  
 
Vendors and other users of SQLI may choose to implement their own conversions to improve performance.  


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

POINTED TO BY: D_OUTPUT_FORMAT field (#3) of the SQLI_DATA_TYPE File (#1.5211) 
               DM_OUTPUT_FORMAT field (#6) of the SQLI_DOMAIN File (#1.5212) 
               C_OUTPUT_FORMAT field (#16) of the SQLI_COLUMN File (#1.5217) 
               

CROSS
REFERENCED BY: OF_NAME(B)



1.5214,.01    OF_NAME                0;1 FREE TEXT (Required)

              Output Format   
              INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      Answer must be 3-30 characters in length. 
              WRITE AUTHORITY:  ^
              CROSS-REFERENCE:  1.5214^B 
                                1)= S ^DMSQ("OF","B",$E(X,1,30),DA)=""
                                2)= K ^DMSQ("OF","B",$E(X,1,30),DA)


1.5214,1      OF_DATA_TYPE           0;2 POINTER TO SQLI_DATA_TYPE FILE (#1.5211) (Required)

              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      Enter the ODBC data type 
              WRITE AUTHORITY:  ^

1.5214,2      OF_COMMENT             0;3 FREE TEXT

              INPUT TRANSFORM:  K:$L(X)>60!($L(X)<3) X
              LAST EDITED:      AUG 20, 1996 
              HELP-PROMPT:      Answer must be 3-60 characters in length. 
              WRITE AUTHORITY:  ^

1.5214,3      OF_EXT_EXPR            1;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:
                                An M expression which converts the base value of X to its external value 

              WRITE AUTHORITY:  ^

1.5214,4      OF_EXT_EXEC            2;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:
                                A line of M code which converts the base value of X to external 

              WRITE AUTHORITY:  ^


      FILES POINTED TO                      FIELDS

SQLI_DATA_TYPE (#1.5211)          OF_DATA_TYPE (#1)



INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):