New post

#Caché

57

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Question
· Oct 10, 2022
Limitations of $ListNext

Hi!

I've encountered a peculiar behavior of $ListNext in Intersystems Cache, where I'm not sure whether I'm doing something wrong, or is it an intended behaviour.

First I am creating a ListOfDT from a string delimited with underscores:

Set tempList = $ListFromString(String, "_")

0 4
0 285

I was attempting to test a Linked JDBC View to MS SQL database and noticed I could not connect. When I look at the JDBC Gateway I noticed that at the Server Level it was down. However the page keeps timing out when ever I attempt to make any changes or start it, it will not respond.

I thought I had found the Cache command to start it but it will not start. Is the following steps correct?

0 1
0 228
Question
· Sep 28, 2022
Up/Down Arrow selection
In cache I am looking for a user to, from read prompt, hit control F and be able, from a list, use the up and down arrow and select an item from a list.

User would hit Control-F and then a list would pop up they can up and down arrow through and select it and it return to the read variable

It would be similar to this.

0 5
0 274

Hello,

First the question then the background:

Can you increase the amount of read operations that are being performed simulatiously to the hard drive where the cache.dat file is located.

Alternatively: Can you increase the amount that is being read with every operation?

Background:
The database is setup with 8k blocks of data that are being read. I'm currently struggeling with a bottleneck concerning the read operations from a disk.

0 3
0 230

Hello All,

I have a class method on the DocRepo server that needs to query the data value of a global variable on the Edge server.

I have looked at the documentation for 'Global Structure,' but I didn't find anything that helped.

Global Structure | Using Globals | InterSystems IRIS Data Platform 2022.1

I am able to access this global easily from the Edge server using the $Get function, but I need to access it from the DocRepo server.

0 8
0 342

How can we insert into a table using a stored procedure?

Table structure :

CREATE TABLE SampleHospital (
Hospital VARCHAR(50),
Location VARCHAR(50),
UserName VARCHAR(50),
UserFullName VARCHAR(70),
LastLogin TIMESTAMP,
LoginCount int)

Procedure Name:

call Custom_MENS_Other.samplesp('2021-11-02','2021-11-04','H001')

0 2
0 206
Question
· Sep 5, 2022
Hl7 viewer component

Hi All

I'm building a ZEN page that will dispay HL7 from a database, and am currently displaying it an textarea.

Is the HL7 viewer that is displayed when HL7 message is selected in a visual trace available as an out of the box tool I can plug into a webpage?

Andy

0 2
0 225

Hello! I am currently creating a class for a small error trap. I have it working and all is good but I really want to change the order of the fields in the SQL return from Alphabetical to something else.

The current Order is ID, ActionType, ErrorCount, ErrorDetails, Model, ResultCode, ResultMessage, Stock and Yard

I would really like for the field order to be ID, Yard, Stock, Model, etc.

Example of current order,

Is this possible?

Thanks in advance!!

0 2
0 149

Credentials for a Productions are stored as plain text in ^Ens.SecondaryData.Password and exposed as plain text via SQL table Ens_Config.Credentials which is not ideal as only admins should know the credentials.

I can create my own adapter etc... to store and use encrypted passwords but does anyone know if there is a standard way to do this in a Production?

Alternatively, am I missing how to secure this so the production can run and someone can monitor and operate a production without access to the SQL table or global?

0 2
1 378