I've found a couple of methods that will tell me whether a package is mapped from another database, but not which database. Is there such a method/routine?

I am having a scenario where I need to check difference between current date and a past date should be less than 31 in Routing Rule. Can anybody help me how to code that?

Hello guys,

Does anyone know what is a process status IPQW ?

We get it in jobs that do some SQL..

Thanks in advance.

Yaron Munz 

It sounds strange though it's embarrassing.

I have a class with ClassMethods written in ISOS and Embedded Python.

The ClassMethods written in ISOS start in the Background as usual. No problems

But my 

Hi,

The company I work for has one software application that uses an IRIS database, with almost all the others using SQL databases.

On a SQL database, we can create local tables and create views. These are invaluable when it comes to reporting, and everyone here is quite up to speed with using SSMS to create functions, stored procedures, etc.

I will devote the third article to a story about the additional features of the project.

znamespace

Very often you need to find out if there is a specific package in the current instance, for example, so as not to duplicate.
To do this, I implemented a modification of the namespace command of the package manager, on the option tab, you need to press the FIND button.

Hi Everyone,

              I am a very new to IRIS Object Script Development. There is a  usecase where I have to execute a .sh file from the object script. I am looking for examples for that, but what I find is the ways to execute the shell commands. Can you please point me to some examples executing a .sh file. Thanks in Advance

Let's say I have a user-generated document template with placeholders and I want to replace them with actual values.

Values could be:

• scalars
• tables
• ...?

So far I wrote a simple find/replace tool that works with RTF format (because it's not a binary format), here's how it works:

Hi All!

I asked previously about the DR server in the cloud but actually, I'm curious about the backup server to use as analytics server more than for recovery in DR case.

There is a recommended practice to use an async mirror as a server for BI (InterSystems Analytics, DeepSee)

The question is if I have PRIMARY in the cloud (AWS, Google, Azure, etc) "how far" should async mirror member be placed? Same cloud, same private cloud or it doesn't matter at all for analytics purposes?

In recent discussion on CachéQuality I was (friendly) blamed for old syntax promotion and deliberate obfuscation of the code. Therefore I decided to clarify my point and shed some light on one of possible source of side effects that may unexpectedly occur with RETURN command with an argument.

Hi All,

I have two tables LB_TestSet and LB_Transfer

LB_Transfer has a list if TestSet row IDs, so i am doing the following join

SELECT 
LBTS_RowID,
,LBTS_CollectedDate
FROM SQLUser.LB_TestSet 
JOIN SQLUser.LB_Transfer ON ($LISTBUILD(LBTS_RowID) %INLIST LBTR_TestSetList)
WHERE LBTS_CollectedDate BETWEEN '2019-01-01' AND  '2019-05-10'

Without the date filter the query returns data, but if i add the date filter no data is returned

I also tried using %INTERNAL, %EXTERNAL TO_DATE('2009-01-01','YYYY-MM-DD')

Hallo Community!

Bitte melden Sie sich zum Webinar "Machine Learning Projekte mit R erfolgreich umsetzen" an: 2. August 2019 um 10:30 Uhr.

Veranstaltungsdetails:

Can you please provide steps to debug in VS code using serenji and how to put break point in VS code, I have tried using F9 but it is not working.

I want to debug API code using postman.

Hello,

I loaded a WSDL from a webservice into my project where executing it returns me a series of Orders related.

My problem is that the provider of this webservice sometimes adds new fields, which I don't even use, and from then on it starts giving Iris a bug, so I need to import the updated WSDL again so that it creates the new property that the provider added.