#Key Question

2

A tag that highlights questions on development, testing, deployment, management, etc using InterSystems Data Platform that are considered to be the most insightful, interesting, puzzling, or important. If a key question includes a best practice, it will also be tagged as such. More details.

Hi Developers,

This May, you've posted 67 new questions on the Developer Community:

Questions

10 Best Questions Ever

1 0
0 226

I have a situation where I have a handful of classes which I need to copy to another Namespace (which uses a different RoutineDB) on the same instance, load it and compile it.

Can anyone help me come up with a command that will do this quickly and easily? Perhaps something with extended reference?

This is somewhat time sensitive so thank you in advance for your ideas!

0 23
0 921

Hi Developers,

This April, you've posted 65 new questions on the Developer Community:

Questions

6 Underlying Benefits of Asking Questions | SUCCESS

3 0
0 121

Hi Developers,

This March, you've posted 89 new questions on the Developer Community:

Questions

21 Questions Game: 110+ Best Questions You'll Ever Ask |

1 0
0 394

Hi Developers,

This February, you posted 86 new questions on the Developer Community:

Questions

How to Use Open-Ended Survey Questions +25 Examples | SurveyLegend

1 0
0 322

Hi folks!

Have a question for those who are masters of interoperability.

I have a basic task of having one CSV with some data. I need to transform one column in the initial dataset and get the new csv with the same form.

What's the best approach with Interoperability?

Should I user record mapper?

Should I use streams, objects?

What is the best practice?

0 12
0 705

Is it possible to retrieve the SQL-Executing process ID (PID) from a process spawned from a UNION %PARALLEL? I have a value set in the SQL-Executing process that I need to replicate in the UNION %PARALLEL spawned process(es). The SQL-Executing process writes the value to a global subscripted by its PID so determining the SQL-Executing PID from the spawned process is what I need. I expected $ZPARENT from the spawned process would hold the SQL-Executing PID but the PID returned is different.

With thanks,

Michael Hill

0 11
0 443

Hi Developers,

This January, you posted a whopping 94 new questions on the Developer Community:

Questions

How to Identify Questions & Optimize Your Site for Q&A, FAQ & More

2 0
0 167

We are upgrading from Health Connect 2018.1.3 to IRIS Health Connect 2022.1, and one thing that we are particularly hesitant about is if our Business Rules will work in the new version.

I am trying to come up with a testing process for bulk testing our rules, and wanted to know if this could be done programmatically instead of having to modify all the Business Operations to have them write the HL7 data to a file. I caught Orlando Health's presentation at GS2022 but I am not sure that will work for my team.

1 10
3 710

I am familiar with $TEXT which can get you any line in the current routine provided you know the offset. For example, $T(+1) will get you the first line of the current routine at the run time. In the same vein, how do I reference the current line number/offset at the run time? Something like $T(+$CURRENTLINENUMBER) where $CURRENTLINENUMBER is not yet known to me function. The sample below would write 3 as the line number.

RTNNAME
S A=1
W $CURRENTLINENUMBER

1 13
1 640

Hi Developers,

This December, you posted 60 new questions on the Developer Community:

Questions

200 Best Questions To Ask To Get To Know Someone

0 0
0 233

I have a table, with autoincremented id

CREATE TABLE users (
    id SERIAL NOT NULL,
    name VARCHAR(30) NOT NULL,
    PRIMARY KEY (id)
)

I can add a new item there with an explicit id 

INSERT INTO users (id, name) VALUES (2, 'fred')

And while my id is autoincremented, I can omit it

INSERT INTO users (name) VALUES ('ed')

So, this time, I don't know the id, and I want to somehow get it.

I could do it with LAST_IDENTITY() function, but it just uses %RowID, and have no relation to the primary id

0 11
0 777

Hi Developers,

This November, you posted 68 new questions on the Developer Community:

Questions

1 0
0 181

This is not an issue in ObjectScript, due to its typeless nature. But it's essential for external programming languages that care a bit more about types of variables.

And in any case, it's still reproducible in ObjectScript. I have table

CREATE TABLE some_table (
        id INTEGER NOT NULL, 
        x INTEGER, 
        y INTEGER, 
        z VARCHAR(50), 
        PRIMARY KEY (id)
)

And data

INSERT INTO some_table (id, x, y, z) VALUES (1, 1, 2, 'z1');
INSERT INTO some_table (id, x, y, z) VALUES (2, 2, 3, 'z2');
INSERT INTO some_table (id, x, y, z) VALUES (3, 3, 4, 'z3');
INSERT INTO some_table (id, x, y, z) VALUES (4, 4, 5, 'z4');

1 11
0 859

Hi Developers,

This October, you posted 80 new questions on the Developer Community:

Questions

How to Use Open-Ended Survey Questions +25 Examples | SurveyLegend

Here are the Key Questions of October chosen by InterSystems Experts:

0 0
0 279

Hi DC Members,

This September, you posted 79 new questions on Developer Community:

Questions

What children can teach us about asking questions - HatRabbits

Here are the Key Questions of September chosen by InterSystems Experts:

2 0
0 261