Stack Overflow
Stack Overflow

Questions tagged [intersystems]

InterSystems is a software company based in Cambridge, MA.

They sell many products related to software development, application integration and data storage including IRIS Data Platform, Caché, Ensemble, and HealthShare.

The products are based on the database (supports SQL, Object, NoSQL access) and the programming language.

Resources

Related tags

130 questions
2
votes
1 answer

Linked server to Intersystems Cache database from MS SQL Server 2005 Browse Catalog

I'm trying to create a linked server in MS SQL Server 2005, pointing to an Intersystem Cache database via ODBC. Below is the query to create the linked server: /****** Object: LinkedServer [CC7] Script Date: 02/22/2011 09:06:39 ******/ EXEC…
George Duckett
  • 31,770
  • 9
  • 95
  • 162
2
votes
1 answer

InterSystems Caché Base64 XML Decode

In Intersystem Cache i export some GLOBALs using $system.OBJ.Export("GCL.GLB", "C:\GCL.xml") Now there is a field that is BASE64 encoded, for example the following…
Joey Erdogan
  • 184
  • 1
  • 13
2
votes
2 answers

How to escape reserved word (keyword) in InterSystems Caché SQL?

I have a column named Date in SQL table, but unfortunately this query throws an error: select Author, Date, Text from Tiny.Comment I've tried to escape the Date keyword with [Date] or 'Date' but this never worked for me.
ZitRo
  • 1,163
  • 15
  • 24
2
votes
1 answer

SSIS - Using ODBC SQL execute task having parameters into a resultset to be imported

First thing first. I'm totally new to SSIS and trying to figure out its potential when it comes to ETL and eventually go to SSAS. I have the following scenario: I have an Intersystems Database which I can connect via ADO .NET I want to take data…
DabolB
  • 61
  • 1
  • 3
2
votes
3 answers

Intersystems cache: and error in Classes : How to solve AND avoid?

I have a single class in Intersystems Cache that writes records on the globals based on the user calling it Iterates on the globals and places results on a string Writes the said result to a notepad file via FILE However, a part of the code…
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
2
votes
2 answers

Convert money to text and keep format

I need to show a dollar range in a query but when I concatenate the values I lose the comma in the output. select '$'||CAST(ROUND(MIN(db.INITIAL_BALANCE),-1) AS money) ||' to '|| '$'||CAST(ROUND(MAX(db.INITIAL_BALANCE),-1) AS money) AS…
CoSpringsGuy
  • 1,615
  • 1
  • 13
  • 16
2
votes
2 answers

Intersystems Cache: Embed SQL always returns only first row

I copied the code from off. documentation: &sql(SELECT *,%ID INTO :tflds() FROM Sample.Person ) IF SQLCODE=0 { SET firstflds=14 FOR i=0:1:firstflds { IF $DATA(tflds(i)) { WRITE "field ",i," = ",tflds(i),! } …
Nikita Vasin
  • 125
  • 1
  • 11
2
votes
2 answers

Intersystems Cache script character limit

what's the character limit (number of characters) which send command has and how can I change it? If I run a long command , it's not getting send completely and an "S" is appended to the end of the string (and string is cut off) so is there a way to…
Mahyar
  • 1,011
  • 2
  • 17
  • 37
2
votes
2 answers

How to get DB resource knowing DB name?

I have database name. I need to get db resource. How? One option I see is to execute Config.Databases:List query and iterate over results till I find required name. After that open db by path and get the resource.
rfg
  • 1,331
  • 1
  • 8
  • 24
2
votes
1 answer

Updating a form generated by a wizard based on a class

I'm following the tutorial here. I created my data class and added a name property using the wizard. I then created a zen form using the wizard, during which I selected the data class created above. Everything worked great. However, I went back…
user736893
2
votes
1 answer

What is the best practice to read full POST request body when using REST in Caché?

Having the following UrlMap: What is the best (easiest?) way to read full request body, without string length limitations ($$$MaxStringLength) or anything that may cut…
ZitRo
  • 1,163
  • 15
  • 24
2
votes
1 answer

How to check if %ZEN.proxyObject has a property in Caché Object Script?

How to properly check that some %ZEN.proxyObject's object has a specific property? In my case I have %ZEN.proxyObject instance. My guess is set p = $PROPERTY(object, "propertyName"). $PROPERTY returns an empty string if property does not exists, but…
ZitRo
  • 1,163
  • 15
  • 24
2
votes
1 answer

Terminal emulation for InterSystems Cache in browser

Sometimes I need to run terminal driven system utilities for InterSystems Caché database but have no ssh access. On the other hand I have web access to this server. Are there any solutions of terminal emulation in browser?
Evgeny Shvarov
  • 468
  • 5
  • 17
2
votes
2 answers

How can I print from DeepSee Dashboards?

Intersystems DeepSee provides a version of Apache FOP for pdf render. I'm facing "java probably not in path" in csp error page. I've tried to set JAVA_HOME at "../@jdkinstallpath@", "../@jdkinstallpath@/bin" with the same result. Cache 2014.2. Any…
Vladimir Kolodyazhnyy
  • 21
  • 2
2
votes
1 answer

How to read a class parameter using Caché SQL?

How do I read a class parameter using Caché SQL? select * from table does not list any class parameters.
O.O
  • 11,077
  • 18
  • 94
  • 182
1
2
3
…
8 9