Caché ObjectScript (COS)

Subscribe to Caché ObjectScript (COS) content with RSS Syndicate content or email

SQL Inbound Adapter - Not returning all the records it should from a View in Micrsoft SQL Server

I am currently working on a issue with WRC on one of my Inbound SQL Adapters not returning all the records it should be.

views

rating

Problem with setting a property

Hi!

While i am trying to write a data i am getting a error as "<PROPERTY DOES NOT EXIST>zFile+15^User.zKQRest.1 *value,%Collection.ListOfObj" but there are values stored in it. How can i break it write it separately.

views

rating

Reverse byte order of an 8-bit string from big-endian to little-endian

Hi,

I have a situation where I write a character stream to a file. The file content gets signed and the signature is sent to a service provider together with the file content.

views

rating

Need clarification on usage of globals and global memory

It is my understanding that when a routine accesses a global it is temporarily stored in global memory.

views

rating

Relationships - iterate through all the Manys' side

I am working with Caché Relationships.

I know how to iterate through the One side of the relationship and for each One iterate through all the various Manys.

views

rating

Indexing of non-atomic attributes

Quotes (1NF/2NF/3NF)ru:

Every row-and-column intersection contains exactly one value from the applicable domain (and nothing else).
The same value can be atomic or non-atomic depending on the purpose of this value. For example, “4286” can be
  • atomic, if its denotes “a credit card’s PIN code” (if it’s broken down or reshuffled, it is of no use any longer)
  • non-atomic, if it’s just a “sequence of numbers” (the value still makes sense if broken down into several parts or reshuffled)

This article explores the standard methods of increasing the performance of SQL queries involving the following types of fields: string, date, simple list (in the $LB format), "list of <...>" and "array of <...>".

views

rating

Protocol Buffers

Hi!

Did anyone try to serialize objects in Caché using Google Protocol Buffers? Your experience will be very helpful for me.

Thanks!

views

rating

file name passthrough and extending a class to override a method

I needed to pass through a file with Ensemble but the operation wasn't writing some filenames as given because the  EnsLib.File.PassthroughOperation

views

rating

Declarative development in Caché

Caché offers a number of methods for going through a collection and doing something with its elements. The easiest method uses a while-loop and lets you fulfill the task in an imperative manner.

views

rating

How to delete Caché global by its value in Caché ObjectScript?

Good day, I have this issue. I have global like: ^myglobal(varX) = $LB(var1,var2).

views

rating

What is the size of Caché ObjectScript variable?

Good day, I would like to find out the size of Caché ObjectScript variable in order to guarantee that my program will not leak, equally in terminal and Caché globals.

views

rating

SQL index for array property elements

Sometimes, it comes in very handy (especially for the EAV model) to use array properties in a class and be able to qickly search by their elements: both the key and the value.

Let’s take a look at a simple example:

views

rating

SQL Inbound Adapter - Key Field Name missing causing issues with Records

I am trying to balance a query using a SQL Inbound Adapter against the output of Ensemble. I am finding that a couple of records here and there are missing in the output file. 

views

rating

Creating an interval-associative array in the Caché DBMS

This is a translation of the following article. Thanks @Evgeny Shvarov for the help in translation.

This post is also available on Habrahabrru.

The post was inspired by this Habrahabr article: Interval-associative arrayru→en.

Since the original implementation relies on Python slices, the Caché public may find the following article useful: Everything you wanted to know about slicesru→en.

Note: Please note that the exact functional equivalent of Python slices has never been implemented in Caché, since this functionality has never been required.

And, of course, some theory: Interval treeru→en.

All right, let’s cut to the chase and take a look at some examples.

views

rating