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.
This series of articles would cover Python Gateway for InterSystems Data Platforms. Leverage modern AI/ML tools and execute Python code and more from InterSystems IRIS. This project brings you the power of Python right into your InterSystems IRIS environment:
The plan for the series so far (subject to change)
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
When I tried to make change in DTL view then only i see following error whereas in XML mode no issue in compilation.
Any resolution and solution ? it looks like some missing xml parser configuration or Pulg ins ?
ensEPC.DataTransforms.dtEcgCEpc081518.dtl was saved locally but could not be saved remotely.
ERROR <Ens>ErrInvalidDTL: Invalid DTL
ERROR #5001: attribute 'sourceclass' is not declared for element 'transform'
ERROR #5001: attribute 'sourcedoctype' is not declared for element 'transform'
ERROR #5001: attribute 'targetclass' is not declared for element 'transform'
ERROR #5001: attribute 'targetdoctype' is not declared for element 'transform'
ERROR #5001: element 'assign' is not allowed for content model '(annotation?)'
ERROR #5001: element 'assign' is not allowed for content model '(annotation?)'
Thanks in advance...
Sudhir
Hey Developers!
Do you want to reap the benefits of the advances in the fields of artificial intelligence and machine learning? With InterSystems IRIS and the Machine Learning (ML) Toolkit it’s easier than ever.
Join InterSystems Sales Engineers, @Sergey Lukyanchikov and @Eduard Lebedyuk, for the Machine Learning Toolkit for InterSystems IRIS webinar on Tuesday, April 23rd at 11 a.m. EDT to find out how InterSystems IRIS can be used as both a standalone development platform and an orchestration tool for predictive modelling that helps stitch together Python and other external tools.
Hi Community!
With this release, we've introduced the support of companies on Open Exchange.
See the details below.
All,
I've been following the " Build your First application with Cache " Learning path and followed to steps for installing the Atelier eclipse plugin.
It appears that the repository for the plugin is missing the "content.xml" file.
Parent Path:Â https://atelier.jfrog.io/atelier/updates/stable/1.3/
Hello,
1)
I am trying to have a ZEN datacombo to display list of Namespaces column using a Class Query.
This Classquery works fine in <tablepane> and also from terminal.
But the datacombo is not displaying the "Namespace" column but only the last two columns. I have tried property displaycolumn="1". But this is not working
Hi,
I have a global that holds users name and date of birth.
I would like to loop through them and check if the date of birth is more than 2 years based on todays date
so I have ^checker("under2", "Eric David", "02-05-2018")
I want to check the birthdate based on todays date to see if it is greater than 2. How do I access the birthdate in the global
Please can you advice
I tried :
set values = $order(^checker("under2"))
set td = $zdate($horolog, 3)
set ol = $p(^checker("under2"), ",", 3) // this does not work
while (values ' = "")
{
set difdays = $system.SQL.DateDiff("d", ol, td)
if difdays > 730
{
set ^value("greater than 2")
}
}InterSystems supports use of the InterSystems IRIS Docker images it provides on Linux only. Rather than executing containers as native processes, as on Linux platforms, Docker for Windows creates a Linux VM running under Hyper-V, the Windows virtualizer, to host containers. These additional layers add complexity that prevents InterSystems from supporting Docker for Windows at this time
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?
I managed to use CacheGlobalOrder to iterate over global and return the next subscript
Â
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.
Â
Â
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.
Â
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.
Hi,
We recover a large amount of data from an external database (SQLServer, about 1 million rows in JDBC).
However, we have treatment time issue.
This process takes more than 30 minutes whereas on a "classic" SQL Server Management Studio type request takes less than a minute.
While searching on the internet, I came across this article: http://makejavafaster.blogspot.com/2015/06/jdbc-fetch-size-performance.html
It explains how in Java, we can tweak the FetchSize parameter of the JDBC driver to optimize this kind of process.
Is there a way to access this JDBC parameter through the EnsLib.SQL.OutboundAdapter adapter?
If not, how do you deal with this kind of situation of large volumetry
I have an above error when purging record map batches and was wondering if anyone out there has ever experienced this and if they have please any advice
Failed to purge body for header 9747192, BodyClassname='******.Batch':ERROR #5823: Cannot delete object, referenced by '*****.Record.%ParentBatch'Are there any third party tools that have native plugins for monitoring Cache?
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
Â
Hi Community!
Good news! One more upcoming event is nearby.
We're please to invite you to join the "J on the Beach" – an international rendezvous for developers and DevOps around Big Data technologies. A fun conference to learn and share the latest experiences, tips and tricks related to Big Data technologies and, the most important part, it’s On The Beach!
We're more than happy to invite you and your colleagues to our InterSystems booth for a personal conversation. InterSystems is also a silver sponsor of the JOTB.
In addition, this year we have a special Global Masters Meeting Point at the conference. You're very welcome to come to our booth to ask questions, share your ideas and, of course, pick up some samples of rewards and GM badges. Looking forward to seeing you soon! 
So, remember!
Date: May 15-17, 2019
Place:Â Palacio de Congresos y Exposiciones Adolfo Suarez, Marbella, Spain
Hi Community!
Please welcome a new video on Developer Community YouTube Channel:
Implementing vSAN for InterSystems IRIS
Â
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
Between Aix(backup) and Windows(recovery) , How to do this?
We use a lot of external MS SQL calls to look up numerous things when it comes to HL7. I am running into an issue where the outbound calls are queued but the message is sent onto the next process before it gets a response. How do I get it to wait till the response gets back from the MS SQL call before sending it onto the next process?
Â
Below is a screen shot of what I am trying to explain...Select Research Study executes at 8:33 the message is sent to the next process at 8:34, but the response of the MSSQL call doesn't come till 9:31.
.png)
Â
Hello everyone 
I have a server configuration in a CSP Gateway installed on a PC (let's call it S2) different from the main one (let's call it S1). This configuration allows me to access a web application that is installed on S1, from a client C asking S2 for this webapp. But for now it works only in HTTP between C and S2, and we would like to use HTTPS (as it already works between S2 and S1).
First here are the tutos found in the doc:
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...
Hello gentlemen,
Â
I have to create a objectscript program that will simulate a mainframe (because it's going to be removed). For my program, I receive data from another program that is written in Delphy by TCP on a preset socket. Â Here is my problem, how can I handle this?Â
Which class shoud my program  extend?
Which Adapter should I use?
My program must be able to read what the delphy one is sending and i don't really know what structure it is in what it is in. So is there a class that can allow me to read it? Thanks for your future anwers.
Here is a sample of what I have thought but doesn't work.
Â
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
In Cache'/Ensemble, by specifying the objectsPackage parameter, dictionaries (and other objects) get projected to tables that can be accessed by SQL queries.
But in IRIS (IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2019.1 (Build 507U) Mon Feb 25 2019 13:47:16 EST), when I created a dictionary with ##class(%iKnow.Matching.DictionaryAPI).CreateDictionary(), it does not get projected to a table.
The class APIs correctly retrieve information about this dictionary.
Am I missing something with IRIS, or is there any issues about this?
IRIS brought us a new WOW feature - SHARDING !
Definitely a great thing!
But how can I find out if it suits my actual applications?
Is there a practical advantage to go for it with my well cooked transactional application?
Or is it just for new still to be designed applications?
