DINIT2B2 ;SFISC/MKO-SQLI FILES ;10:51 AM 30 Mar 1999
;;22.2;VA FileMan;;Jan 05, 2016;Build 42
;;Per VA Directive 6402, this routine should not be modified.
;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
;;Licensed under the terms of the Apache License, Version 2.0.
;
F I=1:2 S X=$T(Q+I) Q:X="" S Y=$E($T(Q+I+1),4,999),X=$E(X,4,999) S:$A(Y)=126 I=I+1,Y=$E(Y,2,999)_$E($T(Q+I+1),5,99) S:$A(Y)=61 Y=$E(Y,2,999) S @X=Y
G ^DINIT2B3
Q Q
;;^DIC(1.5211,0,"GL")
;;=^DMSQ("DT",
;;^DIC("B","SQLI_DATA_TYPE",1.5211)
;;=
;;^DIC(1.5211,"%D",0)
;;=^^10^10^2970806^^^
;;^DIC(1.5211,"%D",1,0)
;;=A set of values from which all domains of that type may be drawn.
;;^DIC(1.5211,"%D",2,0)
;;=PRIMARY_KEY - the set of all primary keys (in SQLI_TABLE_ELEMENT, type P)
;;^DIC(1.5211,"%D",3,0)
;;=CHARACTER - the set of all character strings of length less than 256
;;^DIC(1.5211,"%D",4,0)
;;=INTEGER - the set of all cardinal numbers
;;^DIC(1.5211,"%D",5,0)
;;=NUMERIC - the set of all real numbers
;;^DIC(1.5211,"%D",6,0)
;;=DATE - the set of all date valued tokens
;;^DIC(1.5211,"%D",7,0)
;;=TIME - the set of all time valued tokens
;;^DIC(1.5211,"%D",8,0)
;;=MOMENT - the set of all tokens which have both a date and a time value
;;^DIC(1.5211,"%D",9,0)
;;=BOOLEAN - the set of all tokens which evaluate to true or false only
;;^DIC(1.5211,"%D",10,0)
;;=MEMO - the set of all character strings of length > 255
;;^DD(1.5211,0)
;;=FIELD^^3^4
;;^DD(1.5211,0,"DDA")
;;=N
;;^DD(1.5211,0,"DT")
;;=2960917
;;^DD(1.5211,0,"IX","B",1.5211,.01)
;;=
;;^DD(1.5211,0,"NM","SQLI_DATA_TYPE")
;;=
;;^DD(1.5211,0,"PT",1.5212,1)
;;=
;;^DD(1.5211,0,"PT",1.5213,1)
;;=
;;^DD(1.5211,0,"PT",1.5214,1)
;;=
;;^DD(1.5211,0,"VRPK")
;;=DI
;;^DD(1.5211,.01,0)
;;=D_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
;;^DD(1.5211,.01,.1)
;;=Data Type
;;^DD(1.5211,.01,1,0)
;;=^.1
;;^DD(1.5211,.01,1,1,0)
;;=1.5211^B
;;^DD(1.5211,.01,1,1,1)
;;=S ^DMSQ("DT","B",$E(X,1,30),DA)=""
;;^DD(1.5211,.01,1,1,2)
;;=K ^DMSQ("DT","B",$E(X,1,30),DA)
;;^DD(1.5211,.01,3)
;;=Answer must be an SQL identifier 3-30 characters in length.
;;^DD(1.5211,.01,4)
;;=W ?5,"Must be a valid SQL identifier"
;;^DD(1.5211,.01,9)
;;=^
;;^DD(1.5211,.01,21,0)
;;=^^1^1^2970311^^^^
;;^DD(1.5211,.01,21,1,0)
;;=ODBC Standard data type corresponding to FileMan domains
;;^DD(1.5211,.01,"DT")
;;=2960820
;;^DD(1.5211,1,0)
;;=D_COMMENT^F^^0;2^K:$L(X)>60!($L(X)<3) X
;;^DD(1.5211,1,.1)
;;=Comment
;;^DD(1.5211,1,3)
;;=Answer must be 3-60 characters in length.
;;^DD(1.5211,1,9)
;;=^
;;^DD(1.5211,1,21,0)
;;=^^1^1^2960926^
;;^DD(1.5211,1,21,1,0)
;;=Short description of the data type
;;^DD(1.5211,1,"DT")
;;=2960926
;;^DD(1.5211,2,0)
;;=D_OUTPUT_STRATEGY^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
;;^DD(1.5211,2,.1)
;;=Output Strategy
;;^DD(1.5211,2,3)
;;=This is Standard MUMPS code to format output.
;;^DD(1.5211,2,9)
;;=^
;;^DD(1.5211,2,21,0)
;;=^^1^1^2960926^^^^
;;^DD(1.5211,2,21,1,0)
;;=M code which returns external value, {E} of base value, {B}.
;;^DD(1.5211,2,"DT")
;;=2960926
;;^DD(1.5211,3,0)
;;=D_OUTPUT_FORMAT^P1.5214'^DMSQ("OF",^0;3^Q
;;^DD(1.5211,3,.1)
;;=Output Format
;;^DD(1.5211,3,9)
;;=^
;;^DD(1.5211,3,21,0)
;;=^^1^1^2960926^^^^
;;^DD(1.5211,3,21,1,0)
;;=IEN of default output format in SQLI_OUTPUT_FORMAT
;;^DD(1.5211,3,"DT")
;;=2960926
--- Routine Detail --- with STRUCTURED ROUTINE LISTING ---[H[J[2J[HDINIT2B2 3594 printed Sep 23, 2025@20:27:41 Page 2
DINIT2B2 ;SFISC/MKO-SQLI FILES ;10:51 AM 30 Mar 1999
+1 ;;22.2;VA FileMan;;Jan 05, 2016;Build 42
+2 ;;Per VA Directive 6402, this routine should not be modified.
+3 ;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
+4 ;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
+5 ;;Licensed under the terms of the Apache License, Version 2.0.
+6 ;
+7 FOR I=1:2
SET X=$TEXT(Q+I)
if X=""
QUIT
SET Y=$EXTRACT($TEXT(Q+I+1),4,999)
SET X=$EXTRACT(X,4,999)
if $ASCII(Y)=126
SET I=I+1
SET Y=$EXTRACT(Y,2,999)_$EXTRACT($TEXT(Q+I+1),5,99)
if $ASCII(Y)=61
SET Y=$EXTRACT(Y,2,999)
SET @X=Y
+8 GOTO ^DINIT2B3
Q QUIT
+1 ;;^DIC(1.5211,0,"GL")
+2 ;;=^DMSQ("DT",
+3 ;;^DIC("B","SQLI_DATA_TYPE",1.5211)
+4 ;;=
+5 ;;^DIC(1.5211,"%D",0)
+6 ;;=^^10^10^2970806^^^
+7 ;;^DIC(1.5211,"%D",1,0)
+8 ;;=A set of values from which all domains of that type may be drawn.
+9 ;;^DIC(1.5211,"%D",2,0)
+10 ;;=PRIMARY_KEY - the set of all primary keys (in SQLI_TABLE_ELEMENT, type P)
+11 ;;^DIC(1.5211,"%D",3,0)
+12 ;;=CHARACTER - the set of all character strings of length less than 256
+13 ;;^DIC(1.5211,"%D",4,0)
+14 ;;=INTEGER - the set of all cardinal numbers
+15 ;;^DIC(1.5211,"%D",5,0)
+16 ;;=NUMERIC - the set of all real numbers
+17 ;;^DIC(1.5211,"%D",6,0)
+18 ;;=DATE - the set of all date valued tokens
+19 ;;^DIC(1.5211,"%D",7,0)
+20 ;;=TIME - the set of all time valued tokens
+21 ;;^DIC(1.5211,"%D",8,0)
+22 ;;=MOMENT - the set of all tokens which have both a date and a time value
+23 ;;^DIC(1.5211,"%D",9,0)
+24 ;;=BOOLEAN - the set of all tokens which evaluate to true or false only
+25 ;;^DIC(1.5211,"%D",10,0)
+26 ;;=MEMO - the set of all character strings of length > 255
+27 ;;^DD(1.5211,0)
+28 ;;=FIELD^^3^4
+29 ;;^DD(1.5211,0,"DDA")
+30 ;;=N
+31 ;;^DD(1.5211,0,"DT")
+32 ;;=2960917
+33 ;;^DD(1.5211,0,"IX","B",1.5211,.01)
+34 ;;=
+35 ;;^DD(1.5211,0,"NM","SQLI_DATA_TYPE")
+36 ;;=
+37 ;;^DD(1.5211,0,"PT",1.5212,1)
+38 ;;=
+39 ;;^DD(1.5211,0,"PT",1.5213,1)
+40 ;;=
+41 ;;^DD(1.5211,0,"PT",1.5214,1)
+42 ;;=
+43 ;;^DD(1.5211,0,"VRPK")
+44 ;;=DI
+45 ;;^DD(1.5211,.01,0)
+46 ;;=D_NAME^RF^^0;1^K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
+47 ;;^DD(1.5211,.01,.1)
+48 ;;=Data Type
+49 ;;^DD(1.5211,.01,1,0)
+50 ;;=^.1
+51 ;;^DD(1.5211,.01,1,1,0)
+52 ;;=1.5211^B
+53 ;;^DD(1.5211,.01,1,1,1)
+54 ;;=S ^DMSQ("DT","B",$E(X,1,30),DA)=""
+55 ;;^DD(1.5211,.01,1,1,2)
+56 ;;=K ^DMSQ("DT","B",$E(X,1,30),DA)
+57 ;;^DD(1.5211,.01,3)
+58 ;;=Answer must be an SQL identifier 3-30 characters in length.
+59 ;;^DD(1.5211,.01,4)
+60 ;;=W ?5,"Must be a valid SQL identifier"
+61 ;;^DD(1.5211,.01,9)
+62 ;;=^
+63 ;;^DD(1.5211,.01,21,0)
+64 ;;=^^1^1^2970311^^^^
+65 ;;^DD(1.5211,.01,21,1,0)
+66 ;;=ODBC Standard data type corresponding to FileMan domains
+67 ;;^DD(1.5211,.01,"DT")
+68 ;;=2960820
+69 ;;^DD(1.5211,1,0)
+70 ;;=D_COMMENT^F^^0;2^K:$L(X)>60!($L(X)<3) X
+71 ;;^DD(1.5211,1,.1)
+72 ;;=Comment
+73 ;;^DD(1.5211,1,3)
+74 ;;=Answer must be 3-60 characters in length.
+75 ;;^DD(1.5211,1,9)
+76 ;;=^
+77 ;;^DD(1.5211,1,21,0)
+78 ;;=^^1^1^2960926^
+79 ;;^DD(1.5211,1,21,1,0)
+80 ;;=Short description of the data type
+81 ;;^DD(1.5211,1,"DT")
+82 ;;=2960926
+83 ;;^DD(1.5211,2,0)
+84 ;;=D_OUTPUT_STRATEGY^K^^1;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
+85 ;;^DD(1.5211,2,.1)
+86 ;;=Output Strategy
+87 ;;^DD(1.5211,2,3)
+88 ;;=This is Standard MUMPS code to format output.
+89 ;;^DD(1.5211,2,9)
+90 ;;=^
+91 ;;^DD(1.5211,2,21,0)
+92 ;;=^^1^1^2960926^^^^
+93 ;;^DD(1.5211,2,21,1,0)
+94 ;;=M code which returns external value, {E} of base value, {B}.
+95 ;;^DD(1.5211,2,"DT")
+96 ;;=2960926
+97 ;;^DD(1.5211,3,0)
+98 ;;=D_OUTPUT_FORMAT^P1.5214'^DMSQ("OF",^0;3^Q
+99 ;;^DD(1.5211,3,.1)
+100 ;;=Output Format
+101 ;;^DD(1.5211,3,9)
+102 ;;=^
+103 ;;^DD(1.5211,3,21,0)
+104 ;;=^^1^1^2960926^^^^
+105 ;;^DD(1.5211,3,21,1,0)
+106 ;;=IEN of default output format in SQLI_OUTPUT_FORMAT
+107 ;;^DD(1.5211,3,"DT")
+108 ;;=2960926
