Syndicate content 0  

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

0 2
0 105

The introduction of InterSystems' "Vector Search" marks a paradigm shift in data processing. This cutting-edge technology employs an embedding model to transform unstructured data, such as text, into structured vectors, resulting in significantly enhanced search capabilities. Inspired by this breakthrough, we've developed a specialized search engine tailored to companies.

2 1
1 87

Hi All! We have a new online course that those of you who do integration work / create data transformations may be interested in: Editing Data Transformations via Code. This course is meant to build familiarity with the code behind data transformations in InterSystems products, enabling you to identify their class structures, logical elements, and more.

2 0
0 107
Article
· May 25, 2023 2m read
Reviews on Open Exchange - #28

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

1 0
0 107

I am trying to get a list of databases using the DatabaseByServer method but I am only getting an empty string. I have not found any useful examples of the proper usage of this class/method.

I have tried 2 formats. First

set dbList=""

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList)

I also tried:

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList,"/cachesys/")

In each case dbList is empty string. I can not figure out what I am missing.

0 2
0 105

So being forced to use VSCode out of the box for a new Community install I've hit a small problem, documentation hasn't helped and its a simple problem.

How do I enable auto complete and the property viewer in creating a new .MAC?

So I've created "test.mac" and 'assume' can't remember the method name to open a file (for example), typing

"s f=##class(%Library.File). " in Studio would bring up the methods of %Library.File so I could click the appropriate one, VSCode does not do this (and also didn't show the classes under %Library).

0 5
0 101

Hi Community!

We are excited to announce the first French technical article writing contest!

✍️ Technical Article Contest ✍️

This is the perfect opportunity for all InterSystems technology enthusiasts to share their knowledge and showcase their writing skills. No matter your experience level, everyone is welcome to participate. Articles can cover a wide range of technical topics related to InterSystems products or services. So, let your creativity and expertise run wild!

📅 Contest period: September 2-29, 2024

🎁 Gifts for all: a special gift is prepared for each participant!

🏅 Prizes for the authors of the best articles

4 1
0 86

I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

1 5
0 101

Hi Community,

Watch this video to learn about the latest developments and what to look forward to in InterSystems IRIS:

InterSystems IRIS: What's New & Next @ Global Summit 2024

https://www.youtube.com/embed/s390hVqt9_Q
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 105

Hello,

I have installed the latest version of IRIS (without a web server) to replace my community version with a embeded web server.
I tried to connect Visual Studio Code to my namespace, but I am unable to do so. I keep receiving the message "Not found."
Here is my configuration:

"pc-david": {
"webServer": {
"scheme": "http",
"host": "localhost",
"port": 80
},
"description": "pc-david",
"username": "_SYSTEM"
}

0 9
0 96