Question Viroj (Pat) Pad... · Jun 11, 2020 How to set HL7 value inside "code" in the DTL Hello, In the DTL, is there a way to set a value for the HL7 data element in the code section? For example, set target.SetValueAt("PID:3(k1).1)") = mrn (mrn is the value returned from the SQL query) When I ran the test utility, I got this error message. ERROR ErrException: zTransform+27^testclass.TEST.1 *SetValueAt,EnsLib.HL7.Message -- logged as '-' number - @' set target.SetValueAt("PID:3(k1).1)") = mrn' I tried both target.SetValueAt("PID:3(k1).1)") and target.GetValueAt("PID:3(k1).1)"). That didn’t make a difference. The code still error out. #DTL #SQL #Caché #Ensemble 0 3 0 854
Question Viroj (Pat) Pad... · Jun 9, 2020 Cache SQL question I have a table with 4 column: MRN (primary key), Name, DOB, and Gender. I want to bring in the values on all of the columns into a DTL. Currently, I declare variables for each of the columns and using 3 select statements. #Caché #Ensemble 0 4 0 241
Question Viroj (Pat) Pad... · Feb 28, 2020 How to convert UTC to Eastern time Does anyone know how to convert UTC to Eastern time in the DTL? Input format "YYYYMMDDHHMMSS". Can I use ConvertDateTime() function? If yes, what value do I use in these fields informat, outformat and outf? Thank you. #Ensemble 0 6 0 700
Question Viroj (Pat) Pad... · Jul 25, 2019 How to delete a large data lookup table Hello,I have a large Data Lookup Table (> 150,000 records). It is too large to be opened from Ensemble --> Configure --> Data Lookup Tables to be deleted.Is there another way that I can delete this table?Thank you. #Ensemble 0 3 0 386
Questions