Hi,

I am using the &sql () tag to retrieve the value from the Cache DB.

below is the piece of code i am using:

script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String"
&sql( select columnA,
into :tempVariable1
from TABLE
where COLUMNC = pVariable

quit tempVariable1

i have to return the ColumnA value back to the calling procedure.

can i know how it can be done ? since i am getting an javascript error.

Hello everyone,

We are trying out lists inside persistent classes. Because we may need to use them in a very close future.

So far, I managed to create a class that has a list property which has an indice.

Here is the class in question:

Now that 2017.1 has been released, any indication when we can look forward to the next Field Test starting?

Update on 27-Apr-2017: the 2017.2 FT for Caché and Ensemble is now available via this page.

Update on 02-May-2017: announcement posted here.

I recently installed Eclipse and Atelier and was able to connect to my dev environment and source control. However, when I open a CSP file everything inside <script> tags shows up green as if it's a comment.

I looked through all the preferences but wasn't able to fix this. Has anyone else run into this and/or know a solution?

Thanks,

Orion

I have Caché/HealthShare installed in a local Ubuntu 16.04 LTS virtual machine. I've also installed Apache 2.4 from the apache2 bundle, and enabled SSL. I've configured Caché such that SSL/TLS is enabled on the SuperServer port but not required.

I am running a ZBREAK trace on a legacy FDBMS application that uses arrays but rather than displaying the array value contents, I am seeing logs similar to the following.

Trace: ZBREAK SET LINE=Array Val at BIOPWR+6^BIOPWR

My ZBREAK trace settings are as follows:

Dear people,

I (really) spent hours on finding the maximum size a Global is allowed to be (for Windows, if that matters). All I seem to run into are database sizes (derived from a max number of blocks and block size), but I refuse to believe that is correct because too small to be realistic.

Hello All,

We are looking at taking the HealthShare Health Connect HL7 Interface Specialist certification exam, does anybody know if there is a test/example exam available? I found practice exams for the some of the other certifications but not for this exam?

There is documentation for single dolalr macros but $$$ dollar seems to be referenced on individual pages or not at all.

SQL inbound service execute using schedule task it ends up with error when end time occurs.

Normally task run from 10 to 10:30 every day.

Error in Log: ERROR <Ens>ErrException: <INVALID OREF>%OnClose+10^EnsLib.SQL.GatewayResultSet.1 -- logged as '-' number - @''

Please suggest..

Hello,

Currently, I'm working with a Java Gateway, and I have the following problem. When importing a class into IRIS, which uses methods from a generic class, I can not find the general methods I need. I'm talking about the test2 method from the class test. How can I import the java method that returns a generic?

on red hat, but I would also be interested in a wider answer.

after running a benchmark for 40 minutes, I have been asked if any rollbacks occurred in that time. Rollbacks from SQL or objects.

The application does not record this, so I am looking for a system level record.

The journal entries do the necessary reverse sets and commit just like any transaction. So i don't think i can detect them there.

I need to create a simple REST application.
I`ve created an app:


Also here is a dispatcher class:

We recently went through an Audit of our Security Policies and Procedures when it comes to IRIS. As a result of that Audit, we need to make adjustments to the way that Security is setup within IRIS. I have already done my changes on our TEST and DEVELOPMENT environments, but now I am trying to plan out how do we make these changes in Production.

These changes include moving away from the PWS, setting up Apache/Web Gateway, moving to LDAP instead of using Delegated Authentication, updating Web Applications, updating Resources, updating Services, etc...