Caché | InterSystems Developer Community

Question

Fabio Goncalves · Jan 20, 2016

Ordered Collection/Relationship

Does Caché support a relationship property ordered according to a specifc value?

What shoud be the best approach?

#Beginner #Caché

2 6

0 569

Question

Rustam Ibragimov · Sep 9, 2016

Trimming...

Hello, guys.

I found one interesting moment in Cache Object Script. It doesn't have(or at least I didn't find) trimming function. By trimming I mean if a string has some whitespaces/tabs/carriage returns from very beginning or/and from very right, this function removes them.

I have found several workaround ways.

1. Using Cache Basic

#Caché #ObjectScript

1 6

0 1.8K

Question

William Proctor · Oct 31, 2016

password encryption

How can we make sure that the Cache userid passwords are encrypted on storage? We want to make sure that the Cache passwords cannot be decrypted - how can we ensure that?

#Caché #Security #Encryption #System Administration

0 6

0 1.5K

Question

Andrei Luiz Nenevê · Dec 19, 2016

Slow Loading of page Mojo

Hi,

I have a Zen Mojo application that haves a tree menu, in this menu I'm loading all records from database (about 1500) and the page is very slow, about 2 seconds to load, I don't know how to get faster.

#ZEN #Caché

1 6

0 415

Question

Steve Pisani · Apr 27, 2016

Mixing Bootstrap and jQMobile

Hi,

Is it possible to have a ZEN Mojo application that uses Bootstrap and controls from jQMobile ?

In a fresh installation running Zen Mojo version 1.1.1, my ZEN Mojo page declares:

#ZEN #Caché

0 6

0 554

Question

Isaac Aaron · Jun 3, 2016

Read I/O Performance On >50,000 IOPS

Hello

During some consultant activity I did at a client's I have discovered something very interesting. It seems like the current processing cycle as written in ObjectScript has trouble utilizing an SSD-based storage machine with five-digit IOPS.

#Caché #Field Tests

2 6

0 2.4K

Question

Kurro Lopez · Dec 19, 2016

HL7 Section to JSON

Hi all,

I'm trying to convert a HL7 section to a XML or JSON string.

We need to save the content of PID section into a SQL Column, therefore we need to convert it into a XML o JSON string

is there any easy way to convert it?

I've tried to convert it directly into a DTL, but all my attempts have been unsuccessful

Best regards,

Francisco Lopez

#DTL #HL7 #JSON #XML #Caché

1 6

0 1.4K

Question

Jose Antonio Ca... · Apr 1, 2016

How to extract column sorting of %ZEN.tablePane with or without snapShot

Hi all,

I've been looking for a way to extract the sorting from the ^CacheTemp.zenData global that contain the tablePane snapshot data in order to use it on a report following the current UI sorting criteria.

I could see that if the column is sorted by one column, new entries with this structure are created:

^CacheTemp.zenData(<sessionId>,<snapShotId>,<tablePaneId>,"index",<columnId>,<value>,<dataId>)=""

#Caché #Code Snippet #ZEN

0 6

0 484

Question

Paul Gomez · Apr 28, 2016

Can I migrate a cache.dat file from a Windows instance to a RHEL instance of Caché?

If I have a cache.dat file from a Windows 2012 (64-bit) machine and I want to mount it on a Caché instance running on RHEL, will it work? Assume the versions of Caché are the same.

#Caché #System Administration #Backup

2 6

0 897

Question

Jason Ip · Sep 20, 2016

Caché SQL error (ODBC?) - <<METHOD DOES NOT EXIST>Prepare+41^%SYS.SQLSRV *%New,%sqlcq

So just this morning we started to get this error from all of our SQL-client based tools that connect to our Caché SQL via ODBC:

[%msg: <Error instantiating cached query class in Prepare(): <METHOD DOES NOT EXIST>Prepare+41^%SYS.SQLSRV *%New,%sqlcq>] (State:S1000, Native Code: 190)]

No queries work... any help? stumped over here.

#Caché #SQL

0 6

0 1.1K

Question

Benjamin De Boe · Jan 28, 2016

Can we map CSP pages from another namespace?

Is there a possibility to map a CSP page residing in namespace ABC to a namespace XYZ so you could access it as if executing from XYZ: http://localhost:57772/csp/xyz/MyPage.csp ? Some odd cocktail of web application and package mappings that could make this happen?

The idea is to keep the CSP page in sort of a read-only namespace that only contains code, with the data residing in another namespace. This works for zen pages, but not for CSP.

#Mapping #Frontend #CSP #Caché

0 6

0 491

Question

Ryan Vanden Heuvel · Jun 20, 2016

Caché Efficiency

I am trying to write this loop as efficient as possible. The global has over 10 million records.

#Caché

0 6

0 743

Question

Evandro Santos · May 25, 2016

Runtime Expressions in XML

Hi.

I'm facing a problem when I try to use the Runtime Expression below inside the XData Contents:

<html>#($$$Text("Testing!"))#</html>

It compiles correctly, but when I open the page on the browser I get the message "Expression Error" instead of "Testing!".

How could I use the $$$Text macro with Runtime Expressions? Is there a way to make this?

#ZEN #Caché

0 5

0 381

Question

Jenna Poindexter · Feb 2, 2016

How do we upload a document from a CSP Page

I have a CSP page that needs to allow the user to submit a file. I have a form with an element in it <input type="file" name="file"/> which allows the user to select the file they want to upload from their local filesystem.

How do I go about actually getting the file to be sent to the server?

#Caché #Frontend

0 5

0 1.3K

Question

Heikki Koivulehto · Oct 26, 2016

Shadowing between Caché 5.0.21 and 2016.2.0?

We are finally planning to migrate some ancient Caché applications that are run on Caché 5.0.21 to a new server with Caché 2016.2.0 or so.

I wonder if we could use Shadowing between those to keep the data on the new server up to date?

We would copy the Caché backup from the old environment to the new and do a RESTORE there and then start shadowing.

I know than 5.0.21 is no more officially supported by ISC.

#Caché #Compatibility #Databases #Distributed Data Management #Backup #Journaling

0 5

0 654

Question

Mike Kadow · May 1, 2016

Cannot run Studio and Terminal for the same Instance

I am hoping some of you network guys have ideas. InterSystems seems to be at a standstill. When I startup Studio and try to start Terminal I get License Limit Exceeded. Starting with Terminal and going to Studio, same thing. It started when I put down a 2016 version of Cache on top of a 2015. InterSystems told me to uninstall everything and start fresh. I did that but have the same problems. What can I look at? How do I start to debug this? Although I am the only one on my PC it is really impacting my performance.

-thank you

#Caché #Studio #Terminal #SOAP

0 5

0 1.1K

Question

Scott Beeson · Jun 21, 2016

How to enable a new web service?

I'm following the tutorial here. When I try to call the default Test() method I get the following error:

An error occurred with the CSP application and has been logged to system error log (^ERRORS)

#Frontend #Caché

0 5

0 2.9K

Question

Ponnumani Gurusamy · Sep 15, 2016

difference between method and ClassMethod of Class definition

What are the difference between method() and ClassMethod() in Cache Class definition

#Object Data Model #Caché

2 5

0 2.4K

Question

Amir Samary · Sep 21, 2016

Has Anyone Managed to configure CSP Gateway on CentOS 7 with Apache 2.4 and Secure Enhanced Linux Enabled?

Hi!

I am not system admin. But it used to be very simple to install CSP Gateway on an apache system on Linux with Apache installed. I used to run the CSP Gateway installation program and after it was done, all I had to do was fine tune some configurations on CSP Gateway portal on http://<ip>/csp/bin/Systems/Module.cxw and I was up and running.

#Beginner #CSP #Security #System Administration #Caché

0 5

0 1.3K

Question

Terri Tattan · May 16, 2016

INSERT into a SQL table in another namespace

We have a routine in one namespace.

We have a Cache SQL table in a different namespace.

What is the syntax for inserting into this table from the routine in the other namespace?

Can this be done without using ZN?

Thanks.

#Field Tests #SQL #Caché

0 5

0 1.5K

Question

Evgeny Shvarov · Jul 8, 2016

Top from the group SQL query in Caché

Hi!
There is interesting question in Stackoverflow.
This query works for MS SQL:

SELECT * 
FROM 
(
    SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn
    FROM client_address
) a
WHERE a.rn = 1

There is one answer there, which solves the task:

#SQL #Caché

2 5

0 2.2K

Question

Thomas Chericka · Oct 26, 2016

Source Control dialog box in Cache Studio - pre-Atelier! Cache 2016.1 version and below. Authenticate developer before commit...

Hi,

#Caché #SVN #Development Environment #Studio

0 5

0 453

Question

Eduard Lebedyuk · Nov 22, 2016

How do I log terminal output to file automatically?

As stated in title, I want to log everything I type/get in the terminal to a log file, is there a setting like this somewhere?

Preferably I'd like to enable it once and that's it.

#Beginner #Terminal #Caché

1 5

0 1.2K

Question

Scott Beeson · Jan 13, 2016

Best way to retrieve specific record?

New to CSP and Zen. I've been going through tutorials and have made some progress. Using the "Contacts" tutorial as an example, I'm trying to create a "ViewContact" page. I want this to be linkable so I'm using URI Parameters, which I understand. However, what I'm not sure about is how to retrieve a specific record. Should I use a SQL statement? If so, how?

#SQL #Tutorial #Frontend #CSP #ZEN #Caché

0 5

0 285

Question

Benjamin Eriksson · Mar 7, 2016

SQL in Atelier

Hello!

I'm trying to run a simple SQL query in atelier but it complains about the manager. I'm not sure if this is the best way to do it but here is what I got so far:

#Development Environment #SQL #Caché

1 5

0 358

Question

david clifte · Oct 5, 2016

How to connect to JDBC database using SQL Gateway?

I have to connect to an external database and I'd like to use the JDBC SQL Gateway.

I followed this tutorial [1] to create a JDBC SQL Gateway and after configured it works as expected, but I don't know

how use this connection into source code. Maybe these other tutorial is related [2] and [3].

[1] http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

#SQL #Tutorial #Caché

1 5

0 834

Question

Danny Spell · Jun 9, 2016

Beginning Again

I've been in IT since 1986.

I started with Pr1me INFORMATION and Primos on Pr1me hardware.

In the 90s and 00s, I used D3.

I'm giving Caché a try, but I'm kinda having some difficulty getting started.

I've installed Caché on a 64-bit Windows 7 workstation. It was installed under an administrator's account. From a standard users account, I'm trying to access the Management Portal at:

http://localhost:57772/csp/sys/UtilHome.csp

#Caché

0 5

0 357

Question

Sergey Kudinov · Jun 23, 2016

Looking for 'dead' locks

Can anybody share a code looking for 'dead' locks?

It's not trivial to find such locks manually when there are many records in lock table.

#Caché

0 5

0 530

Question

Ponnumani Gurusamy · Sep 8, 2016

Cache Database

Why we are not using database of join (inner join and outer join) concept. How to we are retrieving the data from different tables in cache. Any Concepts are using in Cache database to retrieve the data.

#Object Data Model #Caché

0 5

0 380

Question

Laura Cavanaugh · Sep 16, 2016

cookies - login vs. session

What's the difference between a Login Cookie and a Session Cooke Path?

What's that cookie in my browser from?

Thanks,

Laura

#Frontend #Caché

0 5

0 2.3K