Hi All,I am converting UTF-8 encoded error files to ANSI files and for that I had written below piece of code. But I am not able to get ANSI encoded files.Code Snippets:Set tReadStatus = ""

# Intro

Recently I reread [this article](https://community.intersystems.com/post/story-support-how-quest-raw-deflate-compressiondecompression-function-leads-node-callout-server) by @Bernd.Mueller.

There are three things most important to any SQL performance conversation:  Indices, TuneTable, and Show Plan.  The attached PDFs includes historical presentations on these topics that cover

What would be the best way to do a HL7 - Business Service to  FRL(Flat Record Layout)- Business Operation?Do I need to use the record mapper to define the file output? Does anyone have an ex

Hi, I have a CSV file with a list of 5000 records in the following formatName, Acc, divisionEric, 1234, 567John, 1235, 987Peter, 3214, 879I just want to copy the Acc, division to a global so eventuall

HiIs this a bug?  We came across it on an older version of Cache but I've also just tried it in version "Cache for Windows (x86-64) 2017.2.2 (Build 865U)" and got the same result.Create a Class l

There have been a number of recent changes to the Lightweight Directory Access Protocol (LDAP) that allow for more granular LDAP configurations. This video will provide a quick overview of LDAP configurations followed by a solution-based deep dive into new…

​​​​​​​Hi, I've been going through the instructions at https://download.intersystems.com/download/atelier.csp  Our development team are on the main hospital infrastructure so we ne

Hi,I'm having the following error when returning a large dataset from a REST API.
"errors":[ {
            "code":5002,
      

Date range queries going too slow for you?  SQL Performance got you down?  I have one weird trick that might just help you out! (SQL Developers hate this!)*If you have a class that records t

As part of a BPL I am building I need to foreach over a some repeating elements and look for a certain value, if said value is present I need to forward the message to another operation. I can't

Hello everyone,I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition' But if I want to search CompanyName have special char %, ex: '

Security requirements around certificates are getting stricter, and revocation lists are a must-have. In this video, we will outline our support for Online Certificate Status Protocol (OCSP), discuss why it is important, and demonstrate how to use it.

Takeaway:…