#InterSystems IRIS

Hi,

Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work
SELECT $$JOB1^KMIGxDESIG() FROM DUAL

Work
sELECT $$JOB1^KMIGxDESIG() FROM DUAL

for this I.m using ODBC 64.

Thanks

Trying to pass pdf to save to custom file using default Trying to pass pdf to save to custom file and %f. but oriignal filename didn't send (it does in terminal). What is missing from setting filename from stream? can the file passthrough not out of box use outputfilename or has wrong default one been sent.

Hello,

I found another question on how to change the language for Studio (but it would've been nice to have my actual language used - Ukrainian, since it's available, or was available). Still, I can't seem to figure out how to get rid of gibberish in the menu without changing the Windows settings:

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?

Hi,

I have IRIS Studio installed on my PC and I want to connect to my IRIS DB on mirrored servers.

What TCP ports are required to be opened on my firewall between IRIS Studio and my IRIS DB?

Hi,

I wonder if anyone could help me.

I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.

My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.

Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:

We currently have a couple of Shell scripts we have written to EnableConfigItem from a Unix (Red Hat) command line, so we can control when a Service/Operation is running via the cron in Unix. We do this by calling

:>iris session xxxxx

using _system user.

During our Security audit it was mentioned that we need to lock down some of the cache users.

I am trying to avoid parsing the SDA3 stream in each process. I am doing some section wise validation in different processes so i need to pass the SDA3 to each process.

When i pass that SDA3 stream that takes a lot of space in HD and takes a lot of time to parse the SDA3 object.

Is there any way that once i parse that SDA3 i can pass the same object to other processes, and i can save my storage and process that fast.

I cannot pass this by default to other process as non persistent object cannot be passed to another job(as per my finding).

Hi, I asked last week and they gave me some little tips. But the truth is I still can't carry out this "Project".

I must perform a REST service, using Oracle 11 database. Eh tried anyway to achieve this.

The purpose is to make a REST service, using the database provided to me and use the procedure that is already created.

According to what I read, I made the connection via JDBC and I had no major problem

Hi,

Is there a database gui tool? like nactive?

I created a Custom Business Service to receive a multipart message with a file and I need to save only the file, not all message. How Can I extract only the file from the pInput to save in a File? This is my code:

I want to create a folder directory through code, but I don't know how to write it

Hello.

We're trying to create a script that compiles everything on a certain namespace, for that we are depending on CompileAll. However it seems that this method doesn't check for a dependency tree even when using flags like: curb.

Hi Community,

Below Query is returning boxes in place of values, I want to list all tragetconfigs , IP addresses, and ports for each business hosts components.

Could you please help me, Otherwise I need to do manually will take a long time to prepare list?