Method : to download the FTP file from intersystem cache : If you have any question please drop a message
Caché
Description
 Â
InterSystems Caché is a multi-model DBMS and application server
Hello,
I am trying to run a simple SELECT STATEMENT in USER NAMESPACE.
SELECT * FROM projectname.table
What is the syntax if i need to get data for a table in another namespace eg. SAMPLES., SYS
SELECT * FROM SAMPLES.projectname.table  is not working.
Thanks in advance.
Jimmy Christian.
Last answer 22 April 2019 Last comment 23 April 2019
Wanted.
  Cache experts from anywhere in the world who would take the opportunity to be sponsored to work in the UK.Â
Â
  Please send your CVs to recruitment@hulatech.com
What is the process in importing a role from one server to another server?
Let's say Server A is our main server that we maintain all of our resources / roles / users. We would like to get these over to Server B, Server C, Server D, etc.
It looks like when we import, there are tables and resources left in the destination servers that are not in the source server. It looks like whatever was in the destination server that was not part of the source server was not deleted from the import.
What is the proper way of exporting/importing a role so that this does not happen?
Last answer 18 April 2019 Last comment 18 April 2019
I managed to use CacheGlobalOrder to iterate over global and return the next subscript
Last answer 18 April 2019
Â
Estimated reading time:Â 6 minutes
Â
Hello everyone,
I was first introduced to TDD almost 9 year ago, and I immediately fell in love with it.Â
Nowadays it's become very popular but, unfortunately, I see that many companies don't use it. Moreover, many developers don't even know what it is exactly or how to use it, mainly beginners.
Â
Â
Overview
My goal with this article is to show how to use TDD with %UnitTest. I will show my workflow and explain how to use cosFaker, one of my first projects, which I created using Caché and recently uploaded to OpenExchange.
So buckle up and let's go.
Â
Last comment 18 April 2019
Open Exchange App The Double Indirection or Yet Another Way to Process Data Arrays in InterSystems IRIS
Hi guys!
Portrait of Madame X, Gustave Caillebotte.
One of the features I like in InterSystems ObjectScript is how you can process array transformations in a specific method or a function.
Usually when we say "process an array" we assume a very straightforward algorithm which loops through an array and does something with its entries upon a certain rule.
The trick is how you transfer an array to work with into a function.Â
One of the nice approaches on how to pass the information about an array is using $Name and Indirection operator.Â
Below you can find a very simple example which illustrates the thing.
Last comment 18 April 2019
Are there any third party tools that have native plugins for monitoring Cache?
Last answer 18 April 2019
I have an xml that has non standard characters and I would like to transform it with xslt so that those characters render in the format &#nnn here is what I have so far any help appreciatedÂ
xslt
Â
Â
<!--?xml version="1.0"?-->
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output encoding="Windows-1252" indent="yes" omit-xml-declaration="yes" method="xml">
>Â <xsl:template match="/Recordset">
  <recordset><xsl:apply-templates></xsl:apply-templates></recordset>
 </xsl:template>
 <xsl:template match="*|@*">
  <xsl:copy>
   <xsl:apply-templates select="@*">
   <xsl:apply-templates>
  </xsl:apply-templates></xsl:apply-templates></xsl:copy>
 </xsl:template>
</xsl:output></xsl:transform>
 XML
Â
Last comment 17 April 2019
Referencing this post:
https://community.intersystems.com/post/producing-json-sql
I'm not sure how to actually interact with the result set I get from doing something like this. I want to return something like:
[{"field1":1, "field2":2}, {"field1":2, "field2":10}]
I'm finding it very difficult to get it in this format, since %Print appends a newline onto the end of the {} object it prints.
Here's the closest I've gotten:
set query = "select JSON_OBJECT('field1': field1, 'field2":field2) from MyTable where x=? and y=?"
   set tStatement = ##class(%SQL.Statement).%New()
   set qStatus = tStatement.%Prepare(query)
   if qStatus'=1 {WRITE "%Prepare failed:" DO $System.Status.DisplayError(qStatus) QUIT
Last answer 13 April 2019 Last comment 16 April 2019
Between Aix(backup) and Windows(recovery) , How to do this?
Last answer 16 April 2019 Last comment 16 April 2019
Continuing on from my last post, I am posting my succesful output for the Day 2 Part 1 below.
A full explanation of Day 2Â part 1 can be found at:Â https://adventofcode.com/2018/day/2Â and the input can be found
at:Â https://adventofcode.com/2018/day/2/input
A brief description of this exercise is that you receive a sequence of strings.
You have to count the if any duplicate or triplicate chars exist in the string. Multiples will exist, but if you find multiple ldupicates / triplicates you will count them once.
At the end of sequence of strings you have to SUM the no. of duplicate / triplicate chars and multiply them together to get a simple check sum value.
I created 2 methods, one to import the data and the second to analyse the strings and populate the duplicate count and triple count properties
Last comment 15 April 2019
Hello All,
Is ther any way to convert RTF content into Text document/HTML docucment in Cache object scripts or by using %iKnow.Source.Converter.
Please advise.
Â
Thanks,
Archunan K
Last answer 15 April 2019
I needed to know programmatically if last ran failed or not.
After some exploring, here's the code:
ClassMethod isLastTestOk() As %Boolean { set in = ##class(%UnitTest.Result.TestInstance).%OpenId(^UnitTest.Result) for i=1:1:in.TestSuites.Count() { #dim suite As %UnitTest.Result.TestSuite set suite = in.TestSuites.GetAt(i) return:suite.Status=0 $$$NO } quit $$$YES }
Last comment 13 April 2019
Hi All,
I would like to download odbc drivers for Cache database to be able to install it on our SQL server.
I am trying to create a linked server to Cache database.
I couldn't find a link for the drivers, there was one post with FTP reference to download but it doesn't seem to work.
I will be grateful for any help.
Thank you
Sap.
Last answer 4 April 2019 Last comment 13 April 2019
Development Environment, JSON, ObjectScript, REST API, Tips & Tricks, Caché, Ensemble, HealthShare, Worldwide Response Center (WRC)
Hi Dev Community,
My team is currently working on a project where we need to post pdf documents to a 3rd party REST API.
The API specifies a field in the JSON request message to contain the 'physical content' of the file as an array of bytes, example of the JSON request as follows - data truncated for readability purposes:
{
  "CaptureSource":2,
  "RecipientID":"ID34",
  "Document": {
    "Guid":"5D847A4E9CC1485382DC4A5F5DC80D6C",
    "EventDate":"2019-01-14T13:23:46",
    "FileExtension":"pdf",
    "FileContent":"JVBERi0xLjQNCiXi48/TDQoxIDAgb2JqDQogIDw8DQogICA......"
   },
  "ActionRequired":false,
Last answer 12 April 2019
Hello,
When i click on the menu to run the Data import wizard from MP, i receive following CSP error
| <UNDEFINED>zOnPageHEAD+229^%cspapp.exp.utilsqleximwizardcontent.1 *schemaname : CSP Error |
Â
It is happening for all the namespaces. Looks like some permission issue. Same issue with Data Export wizard. Help to resolve this will be appreciated.
I am using
Cache for Windows (x86-64) 2017.2.2 (Build 865_0_18763U)
Thanks,
Jimmy Christian.
Â
Last answer 12 April 2019 Last comment 12 April 2019
Hello All,
There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.
Â
For Methods - Is there anything similar ??
I would like to see a similar approach as to the time taken for method to execute.
Is Studio Debugger only option ??
Last answer 12 April 2019
I have a query that I would like to have refreshing at certain intervals lets say every 30 seconds with out refreshing the page content using the META TAGS
refreshes the whole page but I have a jquery function that will run at those intervals that I can use the problem is getting the jquery to call my COS function or is the way to do it with pure COS
Â
Last answer 11 April 2019 Last comment 12 April 2019
After many sleepless nights it's a pleasure to announce the newer, better, moderner ObjectScript compiler which implemented pretty much everything you ever wanted to have in modern ObjectScript:
- Design objective of this new compiler is to parse reasonable subset of current ObjectScript syntax which will look readable for stranger, and not scare them with 1 letter syntax. The good start for compiler was the old-good COS Guidelines from here https://github.com/intersystems-ru/cos-guidelines
- For reasons we mentioned above we do not parse 1 letter syntax. It's declared evil;
- We do not handle dotted syntax for the same reason - modern syntax with {} is proper replacement for dotted syntax blocks;
But we not only parse the modern ObjectScript syntax, we have implemented finally the long-standing request which we always dreamed about. Closures!
Last comment 11 April 2019
Hi All
It's been 6 weeks since my original article 
- - - - -but I have been busy on this project 
I have been looking at/thinking about a replacement for ZENÂ for around 12 months but only really started in depth 4 months ago.
Also been in IT for long enough that I can "get a feel" for a product/technology and make decisions accordingly without going into great detail.Â
Any new technology has a learning curve and I don't want to waste time and effort on something that won't fly.Â
And, as always, I am looking to minimise the learning curve as I want to concentrate on delivering business benefit.Â
Last comment 11 April 2019
I have a wdsl soap request that now requires a header. Where do I modify the header to allow this new value to be sent?
<soapenv:Header>
<Headers xmlns="urn:epic-com.2013.Interconnect.Headers">
<Epic-Client-ID>12349fe5-2ff8-4b79-b723-e69efbabcdef</Epic-Client-ID>
</Headers>
</soapenv:Header>
Thanks
Scott
Last answer 10 April 2019 Last comment 10 April 2019
Hello,Â
Till the end of this summer, I have few hours per day that I can spare. I am keen to invest those hours by being part of a good project as a Technical Consultant  where I can extend my expertise and connect with fellow colleagues of the community.
I have been associated with Intersytems technologies including Cache, Ensemble, Zen, DeepSee for almost a decade and have a good understanding of the same. It was by chance that I ventured into these technologies. Initially I had been working with Sun Microsystems as an Integration Consultant for few years and that's why switching to Ensemble / Cache wasn't tough as they are an integration tool too. Training sessions at Boston also have definitely helped me make the switch
I have a lot of string properties, which need custom but similar Getters and Setters.
Currently I'm generating Getter and Setter in class generation code but that expands class definition.
Is there a way to specify custom datatype which would generate custom getters and setters?
Last answer 9 April 2019 Last comment 10 April 2019
I'm attempting to use the .NET Entity Framework provider that is provided by InterSystems (see: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GBMP_eframe). In our environment, the "Support Delimited Identifiers" option is turned off and we are not allowed to turn it on without significant testing effort. When this setting is off, the SQL that is generated by the Entity Framework provider is not considered valid and therefore the provider doesn't work (it DOES work, however, when this setting is turned ON).
Do you know of any way to work around this issue? Again, we don't have the option of turning the "Support Delimited Identifiers" option ON unfortunately.
Last answer 4 April 2019 Last comment 9 April 2019
Hi,
I am facing issue during LDAP lookup like whenever I used product group parameter in AD explorer to search data from application I am getting empty result. If I set product group parameter as null then based on distinguished name result is generated in application. So if anyone knows about how LDAP works and how parameters are set in AD explorer then please let me know.
Thanks in advance.
Databases, Distributed Data Management, Interoperability, InterSystems IRIS Experience, Caché, Ensemble, InterSystems IRIS, Open Exchange
 For Data Synchronization inside Caché you have a range of ways to synchronize objects and tables.
At DB level you can use Shadowing  or MirroringÂ
This works excellent and if you need just a part of your data to be synchronized you may split your
data into smaller pieces using Global mappingÂ
Or if you need bi-directional synchronization on Class/Table level you can use the Object Synchronization FeatureÂ
The limit of all these excellent features:
They just work from Caché/IRIS to Caché/IRIS.
Last comment 8 April 2019
Hello everyone,
Â
I'm trying to migrate the IDE for programming in COS, we normally use the Studio, but we want to use a more modern IDE. Our team has knowledge with Visual Studio plataform, but we couldn't configurate the compiler and terminal, I installed the extension InterSystems ObjectScript and tried to configurate to connect with my local machine, unfortunately the connection don't sucessed.
Someone has material for how i can connect and compile? Some material i saw show how to use the compiler, but not how can i do the configuration.
Â
Best regards,
Flávio.Â
Last answer 3 April 2019 Last comment 8 April 2019