In my previous article I demonstrated the steps to connect to Caché from Appeon PowerBuilder by using ODBC.
In this article I will demonstrated how to Retrieve data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC

I am using Company.cls from Samples-Data (https://github.com/intersystems/Samples-Data/tree/master/cls/Sample) 

So Let's start:

Step 1 : First of all we need to establish a connection (https://community.intersystems.

I have a SIU message that has multiple AIS segments in an RGS group. I need to reorder the AIS segments based on the AIS 3.1 value.

What is the most efficient way to do this in a transform?

EnsLib.HL7.Adapter.TCPInboundAdapter has a Connected property that I assume is set to the state of the connection session with the remote host; i.e. 1 when Connected, 0 when not. I'm assuming this is the property the Production Configuration web page uses to display the state of the service (green for Connected, red for not Connected, etc.).

How can I interrogate the value of that property of an active service, via a method running in separate process?

(It really seems like I should know this, but I'm just not finding the right magical incantation)

I was looking at the thread of messages on the topic of "Performance when constructing a comma-separated string", and I started writing a response but got distracted, the page refreshed, and I lost my text. I couldn't spend the time rewriting my response, so I started writing this document instead.

I started writing MUMPS at the beginning of my career. I wrote very tight and dense code blocks where exercises such as the string example were authentic challenges.

One of our apps uses a class query to support a ZEN Report and works just fine in that report, producing the expected results every time. We’ve since migrated to InterSystems Reports and noticed that, for a report using the same class query, 100s of extra rows with the same column values appear at its bottom.

We eliminated InterSystems Reports as the source of the problem by recreating the same “extra rows” issue with an Excel spreadsheet calling the same class query as a stored procedure.

What was the issue?

 Hi Community,

Take advantage of our 90 days of replays. 

Go to Virtual Attendee Hub if you are registered.

Go here to register. (Yes, you can still register.)

How to develop an interoperability solution in one code base and then use it to generate many individual interfaces

Overview

In 2009 I wrote the first of several Interfaces for LabTrak. The Interfaces allowed existing National Health Laboratory Services (NHLS) clients to send Patient Demographics and Orders to LabTrak. LabTrak would, in turn, send the results of those tests back to the client. I wrote 3 or 4 at the time and an Interface that fed data from LabTrak into the NHLS Corporate Data Warehouse.

I want to INSERT a record in a database using JDBC in  OBJECTSCRIPT. At the same time, I want to obtain the insert ID. Is there a way to achieve this using the SQL Outbound adapter?

My code is something like this now:

Property Adapter As EnsLib.SQL.OutboundAdapter;

set sql = " INSERT INTO Prenotazioni_CUP "_
                  " (ID, cf
                  " VALUES (SEQTAB.NextVal, ?) "
set status = ..Adapter.ExecuteUpdate(.rs, sql, pRequest.cfAssistito)

Hello,

I don't know if the title is accurate enough. I have a legacy code that I need to optimize. It's a routine written in objectscript. It accepts 4 parameters and runs 6 nested FOR...$ORDER reading a big global.

The thing is when I run the routine the first time it takes around 60 seconds to run. If I run it again it takes 5 seconds. If I wait around 6 to 10 minutes to run it again, it takes 60 seconds again, but if I run it every 1, 2, 3... minutes it still takes only 5 seconds to run.

Hello, Complete novice here.

For some reason one of my productions can't be stopped, it only goes to the suspended state. This is an issue because now I'm not able to start any of my other productions. How can I force the suspended production to stop? I have tried Do ##class(Ens.Director).StopProduction() in the terminal, but I get an error the class doesn't exist.

How can I fix this issue?

Hello community,

It would be appreciated if you could read and respond to us:

➡️ We need to activate a SOAP Operation during a time slot, in order to send messages to the target system, only for a few hours; for example from 4am to 8am.

The requirement is to do this without a scheduled task. This is because when changing nodes, in the production mirrors, there are difficulties, challenges, or issues with scheduled tasks.

Therefore, we need a mechanism that allows us to ensure that the Operation is executed even after a node change.

Hi guys,

My client has a requirement to add a column of random numbers to the query result.

I wrote a function as below:

Class Utils.SqlUtility Extends %RegisteredObject
{

ClassMethod GetSomeNumber(intInput As %Integer) As %Integer [ SqlName = GetNumber, SqlProc ]
{
    Return $R(intInput)
}

}

But in the returned sql result, every row share the same value, as below,

SELECT Utils.GetNumber('456'),
ID, Citizenship, DOB, FirstName, Gender, IDNumber, LastName, PatientNumber, PhoneNumber
FROM CDR.Patient

How may I refactor the function or sql to make the random value really random on each of the rows?

Thanks.

Hi community!

I want to introduce you a new powerful feature from our static code analyzer objectscriptQuality. 

Each time a new IRIS version is released, you need to prepare a roadmap for migration in which you need to spend a lot of time on testing to find where your code is not accomplishing with the newer version. Or maybe you need your code to be compatible with multiple IRIS or Caché versions.

You can now simplify the task running the analysis for the different IRIS and Caché database versions, so you will get the failing code before you start to test.

Hi Guys,

I've bind a textarea to show up in a tablepane cell and it's working fine as follow:

this the column injh question:

    <column colName="FollowUp" header="FollowUp Comments" width="9%" style="text-align:left;" OnDrawCell="txtFollowUp"/>

txtFollowUp method:

Method txtFollowUp(pTable As %ZEN.Component.tablePane, pName As %String, pSeed As %String) As %Status
{
    &html<<textarea name="followup" name="followup" rows="3" text="#(%query(pName))#" style=" width: 95%;" onchange="zenPage.

How to enable mgr/irislib database in iris docker image?

If I start a default image, this database is not create

Hi

We have ODBC 32bit Encryption working on our database with a SSLDEFs.ini file.  However 64 bit ODBC Encryption will not work and give generic error, same error if the ini file is not there for 32BIT.

We have copied the ini file to the 64bit folder?  Any ideas please?

thanks

Hi.
Is it possible to trigger an event on .NET client (C#) from IRIS process? I'm using IRIS Native client to connect to IRIS server.

Regards,
Matjaž

I am receiving the following error in my buisness operation:

ERROR <Ens>ErrException: <UNDEFINED>zGo2+181^mb.MbMainOperation.1 *tSC -- - registered as '-' number - @' set pResponse = ##class(mb.MbMessageResponse).%New()'

From what I understand, the problem occurs in the generated int file mb.MbMainOperation.1 in the method zGo2, with the offset of 181 lines, and the variable in question is a local variable tSC.

However, the line where the error occurs does not refer to tSC in any way

set pResponse = ##class(mb.MbMessageResponse).

Hi Guys,

is there a way to include a datetext in a tablepane cell maybe using OnDrawCell?

I've tried :

    &html<<input type ="date" id="serialno" style=" width: 80%;" />>

but doesn't work with IE 11 and under, so it would be good if I can include datetext component instead.

Thanks

I need to execute multiple DELETE statements in a single query like this

DELETE FROM TableName WHERE ID = 2;
DELETE FROM TableName WHERE ID = 3;
DELETE FROM TableName WHERE ID = 4;

However It does not work when there're more than 2 statements and gives me an error

Expected FROM found WHERE^DELETE FROM TableName WHERE

Using IN is not an option.

Memorial Sloan Kettering Cancer Center — the world’s oldest and largest private cancer center — has devoted more than 135 years to exceptional patient care, innovative research, and outstanding educational programs. Today, we are one of 51 National Cancer Institute–designated Comprehensive Cancer Centers, with state-of-the-art science flourishing side by side with clinical studies and treatment.

We are looking for Healthshare Integration Engineers to join our Health Information Exchange team.

I am using the following code to capture the current Date/Time and Date/Time from the previous 15 minutes 

set now=$horolog
$$$TRACE("now:"_now) set time15min = $piece(now,",",*) - (15 * 60)
$$$TRACE("time15min"_time15min) set after = $piece(now,",",1)_","_time15min
$$$TRACE("after"_after) set datetime15=$zdatetime(after, 3)
$$$TRACE("datetime15"_datetime15) set datetimenow=$zdatetime(now, 3)
$$$TRACE("datetimenow"_datetimenow) set datetime15=$replace(datetime15," ","T")
$$$TRACE("datetime15"_datetime15) set datetimenow=$replace(datetimenow," ","T")
$$$TRACE("datetimenow"_datetimenow)

The issue I am having is that it errors at midnight as it cannot account for the previous day and the previous 15 mins (Time being 23:45)

Is there an "If" statement I can write to resolve this or something else?

We're hosting our Deltanji and Serenji user group session tomorrow - there's still time to register, if you haven't already. 

We'll be showcasing some advanced features of Deltanji and Serenji in VS Code with time for a discussion - so feel free to bring along any problems you need help solving or share your feedback on our tools. We'd love to hear your thoughts. If you're interested in our tools this is a great chance to hear what others have to say, as well as asking your own questions.

Date: Wednesday, November 3rd

Time: 11-12pm EDT / 3-4pm GMT.

Let us know you'll be attending on Eventbrite. 

We hope to see you tomorrow, but if you're unable to make it you can email me at laurelj@georgejames.com and I can share a recording of the session. 

https://osu.wd1.myworkdayjobs.com/OSUCareers/job/Medical-Center-Campus/Sr-Applications-Development-Analyst_R20670-2?shared_id=2485643a-341c-43b7-b1c4-c85f8715a77b

Position Summary 

Serves as the primary contributor and consultant for patient care services in the planning, design, development, implementation, functionality and evaluation of integrated health information systems that support and enhance practice, administrative and management needs and patient outcomes.

Hi Community:

Just want to let you know that Gartner Peer Insights is offering US$25 gift cards for completed product reviews. Here is the link: https://gtnr.it/3ulVX4K
 

I have created on class method which execute below command

From terminal : _System account works fine where code=0

From Studio : _System account give syntax error where code=1

set code = $zf(-1,"python C:\keys\GetToken.py")

w !, code

Hello everyone,
I'd like to export Ensemble globals, but without Ensemble messages, this way:

^^database>s list("Ens*.gbl,'Ens.Message*.gbl")=""
^^database>write $SYSTEM.OBJ.Export(.list, "/tmp/globals.xml")

Documentation says that it could be done by adding an apostrophe, but it doesn't work for me - all Ens* globals are still exported.
What I'm doing wrong? Thanks!

I am relatively new to Intersystems cache database management. As I understand it, a database is set with a maximum size or unlimited and the size of each space allocation for the database is defined. My understanding is that the cache database will then manage the allotment of space to the database as the current space allocation is consumed. Though I do not know why one would want to do this, I have been told that the space allocation to a database can be set to be handled manually. This is something, if true, I was not aware of.