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

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

How do i change the language of my InterSystems studio

I did a clean install of InterSystems ensemble on a new computer. However, even though my OS and my browser are set the English, the Ensemble installation is in dutch.

14

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

Blurry Images on Atelier 1.0.263

Hi,

I just updated Atelier to 1.01.263 and now many of the Atelier icons/images are blurry and the spacing in the Atelier Explorer doesn't look right. This is on Windows 10.  Is this a known issue? Are there any settings I need to adjust?

21

views

0

rating

How do I import an exported ensemble operation?

I created an outbound FTP File Adapter operation and I need to duplicate it to like 10 namespaces.  I went to tools and clicked "Export" and saved it to the filesystem as an XML file.  Now...

22

views

0

rating

Introduction to .Net Gateway - use external .net library from Cache Object Script

Integrating Cache with .net may be difficult, as we need to know both technologies and tools involved. Let’s follow the simplest possible example and see the pitfalls lurking on our way.

 

124

views

+ 3

rating

Upgradation Error

I tried to restore a backfile(.cbk) from ENSEMBLE 2010 version to ENSEMBLE 2009 version studio, it shows me "Class dictionary out of date, please run upgrade utility error $SYSTEM.OBJ.Upgrade()" message.

18

views

0

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

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

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

Encoding issues with plain text file and server

In my country we speak in spanish. My developing machine uses windows 8.1

42

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

Linux Transparent HugePages and the impact to Caché

** Revised Feb-22, 2017

 

Introduction

Memory is managed in pages.  The default page size is 4KB on Linux systems.  Red Hat Enterprise Linux 6, SUSE Linux Enterprise Server 11, and Oracle Linux 6 introduced a method to provide an increased page size in 2MB or 1GB sizes depending on system configuration know as HugePages.

At first HugePages required to be assigned at boot time, and if not managed or calculated appropriately could result in wasted resources.  As a result various Linux distributions introduced Transparent HugePages with the 2.6.38 kernel as enabled by default.  This was meant as a means to automate creating, managing, and using HugePages.  Prior kernel versions may have this feature as well however may not be marked as [always] and potentially set to [madvise].  

Transparent Huge Pages (THP) is a Linux memory management system that reduces the overhead of Translation Lookaside Buffer (TLB) lookups on machines with large amounts of memory by using larger memory pages.  However in current Linux releases THP can only map individual process heap and stack space.

749

views

+ 2

rating