Visualizing the data jungle -- Part I. Let's make a graph

This is the first article of a series diving into visualization tools and analysis of time series data.

views

rating

Using WHERE clause on a sub-query populated column

Hi,

Is it possible to use the value of a column that is populated by its own subquery,  in the WHERE clause of the outer-query ?

The following fails (it does not parse syntactically):

views

rating

Old/New Dynamic SQL Cheat Sheet

The newer dynamic SQL classes (%SQL.Statement and %StatementResult) perform better than %ResultSet, but I did not adopt them for some time because I had learned how to use %ResultSet.

views

rating

ODBC to Cache with Dynamic Table Names

Hello! So, my knowledge on the Cache database is extremely limited, and I was hoping I could find some assistance here. I'm connecting to the DB via ODBC.

views

rating

Trigger a class compilation

Hi all,

 

I was wondering if there is any way to trigger the compilation of a class based on the compilation of another (unrelated) class. For example:

Class 1 = test.class

views

rating

How to configure the size for global buffer

Below are the output messages when Cache start.

Allocated 178MB shared memory: 1MB global buffers, 26MB routine buffers

views

rating

How to dynamically change the entry defined in SQL storage map

I have a class and I would like to dynamically change its selectivity attribute in run-time and then call $system.OBJ.Compile to

views

rating

Connecting to a web service

Hi,

I am new to coding web services and trying to connect to an API that returns its format in xml or json.

views

rating

EmergencyId startup

Hello, I am writing to request assistance on an issue I appear to be having when accessing Ensemble.

views

rating

Estimation techniques in intersystems

how do we do estimation in Intersystems ? what is the unit of  work that we refer for intersystems ?

views

rating

How to encrypt column value in sql?

hi

   I want to update  some columns in one table like this:

 

    update table1 set col1=%SYSTEM.Encryption_AESCBCEncrypt(col1, 'key')

 

but the error is 

 

views

rating

iKnow demo apps (part 1) - Knowledge Portal

InterSystems' iKnow technology allows you to identify the concepts in natural language texts and the relations that link them together. As that's still a fairly abstract definition, we produced this video to explain what that means in more detail. But when meeting with customers, what really counts is a compelling demonstration, on data that makes sense to them, so they understand the value in identifying these concepts over classic top-down approaches. That's why it's probably worth spending a few articles on some of the demo apps and tools we've built to work with iKnow. 

In the first article in this series, we'll start with the Knowledge Portal, a simple query interface to explore the contents of your domain.

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

Is there a function for convert string to hex?

hi

  is there a built in function for convert string to hex.  for example

 

"abc"   convert to "616263"

 

 

thanks

views

rating

Use a global stored in variable.

Greetings, 

How can I store a global name in a variable, ie: x="^G" and then use x like this, as if it were the global:  y=$o(x)  ?

Please advise,

Thanks... 

views

rating