- 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 Feb 19, 2025@00:17:50 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
