#Caché

Let's say I have a list structure:

set list = $lb("stri,ng", $c(0), 2)

I want to replace all $c(0) elements with empty elements, so my list would look like:

set list = $lb("stri,ng", , 2)

What's the fastest way to do that?

Hi,

Does anyone know why the SYNTAX error appears?

Hello!

How to delete archieve file, i'm used ##Class(%File).Delete(fileNamewithPath), but this method doesn't help,

Anybody know, how to delete file exactly?

I want to call java method and return $lb structure from it.

JDBC jar seems to contain relevant class - com.intersys.jdbc.CacheListBuilder, but so far I only managed to return a string that looks like a list.

Here's my java code:

Does anyone have any experience with getting, unfortunately, an older version of Cache to authenticate via SMTP to send email? I have verified that the settings are set up properly on the mailbox as I have successfully sent an email from a LAMP server, which comes from the same IP address.

If you have any thoughts, I would greatly appreciate it.

This is the error I receive

ERROR #6034: SMTP server connection failed during MAIL FROM command: <READ>zSend+105^%Net.SMTP.1.

(Originally posted by Timur Safin on Intersystems CODE, 3/2/15) This code snippet is a routine that parses options saved in an arguments array. The subroutine "test" runs the code:

We are running old VB code on a Windows 2012 R2 server.

In the last month the following error has been happening.

Failure to create CacheObjectConnection.
Failure in GetClassInfo for CacheObjectConnection

Factory not connected to server
Send to Cache' failed

Neither the the code or Cache instance has not changed.

Cache 2017.1.1.111.0

The code:

Dim bRtn As Boolean
Dim objCacheObject As Object
cntr = 1

Given the class name, how could I leverage the %Dictionary API to

1. Get the ID Key field

2. Check the ID Key field is Integer type.

3. Given a property name, how could I check there is a UNIQUE constraint/index on it and also the property is Integer type?

Thanks you.

I'm Trying to create a "Windowing Function" In Cache similar to SQL Server. I'm trying to create a Row Number for every account number (Example Below). I know I can use the %Vid function to create the Row Number but I need the row number to reset with every new account number. In SQL Server it would be Row_Number over (Partition by account number order by account number). and Example of what I am trying to create is below.

Row Number Account Number

1 1

2 1

We are building our CI/CD pipeline. If we remove a cls file in git how we can delete it from Cache?

Hi,

I'm trying to execute a function in a loop using studio but I'm having an error; "ODBC driver for sql server Invalid precision value"

Any help please?

Example :

for i=1:1:2{

...

InterSystems products (InterSystems IRIS, Caché and Ensemble) support AIX on Power 9 chips starting with:

Caché/Ensemble 2017.1.3

InterSystems IRIS 2018.1.1

Hi,

I'm trying to find the faster way to get the data from a class, and I find it very slow compared to traditional globals. So, I hope some of you can bring some light to me :-)

I have thousands of registers in a class, and to access it quickly I'm going with $o at the index. From there, I get the values using $listget(). Something like that:

Hello community,

I am pleased to announce version 1.1 of this project. Now Russian