SQL

Syndicate content 29 

Description

SQL is a standard language for storing, manipulating and retrieving data in relational databases

Sorting: By Date

What do you do if you want to have the ID field have a meaningful name for your application? 

Sometimes it comes to pass that when you're making a new table that you want to have the unique row identifier (a.k.a. IDKEY) to be a field that has a name that is meaningful for your data.  Moreover, sometimes you want to set this value directly.  Caché fully supports this functionality and it works   Suppose you have a class Test.Kyle.  The data will be stored like so:

^Test.Kyle(IDKEY)=$LB("",Field1,Field2,...,Fieldn)

Continue Reading
Kyle Baxter's picture
Post by Kyle Baxter 2 February 2016
Last comment 3 February 2016
+ 3   0 5
2

comments
263

views

+ 3

rating

Attached to this post is a PDF document outlining some of the key enhancements included with 2016.2. I will be giving a WebEx session that is open to all tomorrow at 11 AM EST. Once the WebEx is over I will be adding a link to the recording for those who cannot attend.

2016.2 Field Test Launch
Tuesday, February 2, 2016
11:00 am  |  Eastern Standard Time (New York, GMT-05:00)  |  30 mins
 
Meeting number:    747 673 229

Continue Reading
Bill McCormick's picture
Post by Bill McCormick 1 February 2016
+ 4   0 6
0

comments

217

views

+ 4

rating

Hi!

Is there any simple way to query data about processed messages in all Ensemble productions?
What I ultimately would like to do is to periodically export that data to another system and run statistics on it.

I've been digging around in the SQL tables view and Ens.MessageHeader seems to contain most of what I'm after.
Using ODBC I could access that table view and query data, but only for one namespace per DSN it seems.

Continue Reading
Andreas Östlund's picture
Post by Andreas Östlund 25 January 2016
Last comment 31 January 2016
0   0 5
0

answers

5

comments
280

views

0

rating

The object and relational data models of the Caché database support three types of indexes, which are standard, bitmap, and bitslice. In addition to these three native types, developers can declare their own custom types of indexes and use them in any classes since version 2013.1. For example, iFind text indexes use that mechanism.

Continue Reading
Alexander Koblov's picture
Post by Alexander Koblov 29 January 2016
Last comment 29 January 2016
+ 10   0 8
1

comments
1246

views

+ 10

rating

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?

Continue Reading
Scott Beeson's picture
Post by Scott Beeson 13 January 2016
Last comment 14 January 2016
0   0 4
0

answers

5

comments
143

views

0

rating