#Caché

Could you help me please. I am a VistA Application Administrator for the State of Tennessee and I have been using your web site: https://www.bmirwin.com/vnode/dictionary/index.php to write reports for the Health Departments in my state and I see it was shut down on 9/1/21.

I have a client running cache on an AIX platform. I put together a objectscript to allow for the viewing the processes running against the database using a select from SYS.Process. One of the values I want in the view of the processes information is Jobtype but I want to convert it from the numeric value to a string value. In the Intersystems documentation there is a reference to an include file $syPidTab.inc that should include macros that make this translation. I have not been able to track down this include file.

In Caché, it's possible to iterate a local array using $QUERY() :

set a("foo") = 50
set a("bar") = 30

set key = "a"
for
{
     set key = $QUERY(@key)
     quit:key="" 
     write key_" = "_@key
}

This code works perfectly, unless it's called in a job (eg: a routine called by the JOB command).

Hi

We have an application that is logged using AWS SSO.
We are passing username and password from the AWS SSO to our application for validating the user.
But what we need is, we need to login to application without using the password.
Is there any possible way available for this?

Thanks,
Syed M

Can someone tell me why this query

select vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf, vet.numConselho, vet.nome, svp.SEQ_SOLICITANTE, vet.numConselho , vlab.numConselho
from RPE.Veterinario vet
inner join RPE.VeterinarioLab vlab
    ON vet.conselho = vlab.conselho
    AND vet.numConselho = vlab.numConselho
    AND vet.uf = vlab.uf
left join MySevi.SolicitanteVeterinarioPaciente svp
    on svp.ID_VETERINARIO = vet.ID
where svp.ID_PACIENTE in ('6408||284144||47633', '6408||284145||47634')

does't return any value and this query

After linking in Oracle Table with Field Column's Data Types of NUMBER, my updates into these table fields are resulting in data that is being rounded to 2 decimal places. I insert a record with 1234.1234 and 1234.12 is stored.

It appears Cache xDBC might be manipulating my values prior to sending to Oracle. Is there a setting or system parameter that is controlling this? If so, is there a way to relax this from occurring so the values I send are being stored in Oracle with the same values?

I'm trying to debug a CSP page but I'm not able to set up a breakpoint into <script> tag.

Is it possible to setup on CSP files? Am I forgeting something?

PS:

this is the tag

Hello,

We need to upgrade our cache instance from 2016.2 to the latest version.

I find the documentation about the "Upgrade Path" but I cant find where I can get the files to upgrade in the documentation.

Also I cant find how to make this upgrade, they talk about strategies but dont talk how to perform the task to upgrade.

Is there any documentation of how to make and upgrade and where I can get the files?

Hi developers!

Do you know a CRM that is built with InterSystems IRIS or Caché or Ensemble on a backend?

Hello, first of all thanks for your time reading our question 💭

We would need to be able to transform a hexadecimal string to a base64 coded one. 🔄

To be specific, our use case is this:

1º We have our hexadecimal as follows:

4C5803040101020179C3913EC3BA7C4C580708010101021824584D4C

2º We convert it to ASCII:

LXyÑ>ú|LX$XML

using this online tool:

Hi community,

This is another article about how to perform actions that you can do in the web portal but via code.

Today.... Add a default setting value by code

I am unable to download Cache Studio from the Intersystems web page. The download link times out.

https://www.intersystems.com/developing-with-intersystems-iris/

Scroll down and click on 'Studio'. Spins then times out.

@Andreas Dieckow can you provide any insight?

Joe

Dear,

From time to time I get the following error after executing a select statement:

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]
[Location: <ServerLoop>] InterSystems.Data.CacheClient.CacheException [SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]

After repeating the query, the query succeeds.

How do I start debugging this type of issue?

Hello,

First of all thanks for your time reading our question, and thanks for your replies and help

We would need to know if a patient has less than 65 years old, using their birthday from the PID 7.1

So far we have developed the following code: