Caché

Subscribe with RSS Syndicate content or email

How to add the case insensitive index to a class?

Hi!

Consider I have a class Package.Data with Property UniqueStringValue as %String.

I introduced the Index for this property:

6

views

0

rating

How to deploy resources and roles?

Hi, Community!

Consider I have ResourceA which is used by role RoleA in dev environment and want to deploy it with the solution on a target system.

7

views

0

rating

Collision for SHA-1 hash algorithm

The recent announcement of a collision for the SHA-1 hash algorithm has caused some consternation:

https://shattered.io/

12

views

+ 2

rating

Is there any way of paginate SQL Query in Caché?

Hi,

My doubt is about the SQL Query in Caché:

52

views

+ 1

rating

How common is it to utilize $ZSTORAGE?

While I can see the benefits that $ZSTORAGE could have if used properly, I have not seen it used in the environments I have worked in. I was wondering if there are any developers that promote its usage.

58

views

0

rating

How to run REST.DocServer clss file in local server?

I'm new to learn Rest Services in Cache.

I have REST.DocServer class file in local system. When I tried to run this file I have the error as HTTP ERROR 403. 

43

views

0

rating

Using InterSystems Caché and Apache Zeppelin

I' have done some tests with Caché and Apache Zeppelin. I want to share my experince to use both systems together.

64

views

+ 5

rating

What's the best way of doing Reports in Zen Mojo.

Hi everyone, I have and Zen Mojo application, it's all working but I have some doubts about what is recommended to use: There is some reports of employees, for example, and actually I'm using some plugins : "Excel

51

views

+ 1

rating

Parse %ObjectIdentity

Hi!

I'm trying to implement %OnAfterDelete ClassMethod for persistent class. As a parameter it gets oid As %ObjectIdentity for the deleted object.

39

views

0

rating

Making encrypted datafields SQL-searchable

Overview

Encryption of sensitive data becomes more and more important for applications. For example patient names, SSN, address-data or credit card-numbers etc..

Cache supports different flavors of encryption. Block-level database encryption and data-element encryption. The block-level database encryption protects an entire database.  The decryption/encryption is done when a block is written/read to or from the database and has very little impact on the performance.

With data-element encryption only certain data-fields are encrypted.  Fields that contain sensitive data like patient data or credit-card numbers. Data-element encryption is also useful if a re-encryption is required periodically. With data-element encryption it is the responsibility of the application to encrypt/decrypt the data.

Both encryption methods leverage the managed key encryption infrastructure of Caché.

The following article describes a sample use-case where data-element encryption is used to encrypt person data.  

But what if you have hundreds of thousands of records with an encrypted datafield and you have the need to search that field? Decryption of the field-values prior to the search is not an option. What about indices?

This article describes a possible solution and develops step-by-step a small example how you can use SQL and indices to search encrypted fields. 

75

views

+ 3

rating

How to Export Data to Excel in Cache Object.

Please Give a simple program for how to export data to Xls format in Cache Objects.

60

views

0

rating

CSP

Hi All,In CSP how to call one method to another method (i.e) i created one script language as cache from that one script to another script that one also a cache script ,how to call the script.

44

views

-3

rating

Notepad++ Language Pack for COS?

Does there exist a User Defined Language pack for Caché ObjectScript for use in Notepad++? I'm hoping some friendly developer somewhere may have created one .

96

views

0

rating

How to rewind results of %SQL.StatementResult

Hi, is possible rewind results of %SQL.StatementResult?

I not find a solution.

63

views

0

rating