SQL


Subscribe to SQL content with RSS Syndicate content or email

Using Embedded SQL in Caché Object Script Part #1

Embedded SQL is a tool that allows us to execute SQL statements in Caché Object Script.

118

views

+ 4

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

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

Regarding the AggregationId...

I use the HS_IHE_ATNA_Repository.Aggregation table a lot.  Someone just referred me to the HS_IHE_ATNA_Repository.Document table, which has an AggregationId column.  

57

views

0

rating

Property as Simple list of string values

I have a property, Emails, that needs to contain a list of comma-delimited values, or "".

87

views

0

rating

Determine which repository a document came from via SQL

I have the following query which tells me how many documents were retrieved for each customer, but it only works for the "on-demand" customers:

43

views

0

rating

How can I override the getter for serial property?

I want to override getter for a serial property as a whole, because getter code depends on a class in which a property is defined.

Let's say I have CS.Serial as a serial class:

68

views

0

rating

[2014.13] having to constantly Purge Cached Queries because of 'method does not exist' error

We've been noticing that we're getting this (https://community.intersystems.com/post/cach%C3%A9-sql-error-odbc) error more frequently

72

views

0

rating

Kyle Lists Common Problems and Their Solutions: 7 Reasons A Query Returns No Data

So I know it's been a while, and I hate to let my adoring fans down... just not enough to actually start writing again.  But the wait is over and I'm back!  Now bask in my beautiful ginger words!

129

views

+ 7

rating

Best way to Page Results for External SQL query

When working with a large query executed though an ODBC connection what is the best way to allow the paging of the results at the client side.

98

views

0

rating

How to determine row level security at runtime

In addition to its general security, Caché offers SQL security with a granularity of a single row. This is called row-level security. With row-level security, each row holds a list of authorized viewers, which can be either users or roles. By default access is determined at object modification Some time ago I became interested in determining row-level security at runtime. Here's how to implement it.

82

views

+ 1

rating

The Art of Mapping Globals to Classes (5 of 3)

Mapping Examples

 

98

views

+ 4

rating

The Art of Mapping Globals to Classes (4 of 3)

The Art of Mapping Globals to Classes (4 of 3)

 

The forth in the trilogy, anyone a Hitchhikers Guide to the Galaxy fan?

116

views

+ 2

rating

Sql - Exists With queries in Caché?

Hi guys.

Do You known If Caché has suport to Common Table Expressions (With queries)

83

views

0

rating

ODBC refuse to take credentials on the fly from a .NET applikation

Hi!

I'm trying to connect to one of our Ensemble servers Cache database from a C#-windows form . I'm running the client from my local computer with OS win7.  Using .NET FW ver 4.5.2 in the client.

47

views

0

rating