SQL

Subscribe to SQL content with RSS Syndicate content or email

Insert SQL

I am inserting rows in a table. This table is appearing in all namespace as I did global mapping. 

views

rating

The Interns are Coming!

The Data Platforms department here at InterSystems is gearing up for this year's crop of interns, and I for one am very excited to meet them all next week!

views

rating

DDL for collection properties

How do I write DDL script for collection properties?

For example I want to create the following class:

views

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?

views

rating

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

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

 

views

rating

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

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

 

views

rating

Connect PRTG to Cache

I am trying to set up a sensor in PRTG to connect to Cache, specifically the ens_util.log, so that I can have a live feed of my error count. I am having trouble getting the sensor to log in to Cache.

views

rating

Eclipse SQL Client Plug-In for Caché?

Atelier Users:

views

rating

JSON_OBJECT issue

Hi All,

I use SQL function JSON_OBJECT to get data as a JSON object.

However, sometimes I get error with function JSON_OBJECT when values contain [, ], { or }.

Error:

views

rating

It's upgrade season - is your SQL Body ready?! Keep your SQL Slim and Toned for Upgrade Season!

 It's almost time to get your customers upgraded to new versions - are you worried about showing off your SQL Performance after upgrades?

views

rating

How use REGEX (Regular Expression) IN SQL statement?

Hi guys.

 

I need validate a field string in a table. It needs have a specific mask

I want use regex + CASE expression

There is any function to this purpose in SQL?

views

rating

Is there a way to rebuild indices for all the classes in a given namespace?

I'm moving *D globals from DatabaseA to DatabalseB.

After importing globals I need to rebuild indices for all the imported persistent classes.

views

rating

Is it possible to modify the values of an insertion during a trigger ?

Hello, we have a few hundreds of triggers to port from Oracle to Cachè for a migration project, and many of them have to change (for example, normalize a value, null it, etc) the value which is being inserted.

views

rating

Query

Hi All, In Cache Table i have stored the data value as horlog format ,by query how to retrive the data when i give the data field as date format.

views

rating