InterSystems FAQ rubric

You can see the free available space for the database using the radio button "Free Space View" in Management Portal: System Operation > Databases.

And it can be obtained programmatically by the FreeSpace query of the system class SYS.Database.

Hi All,

I am trying to execute my SQL query using ExecDirect() method and it returns a ResultSet. No doubt it works fine after this I am trying to fetch each value using a loop code below. But before that, I am also checking for %SQLCODE = 100 which is for an empty resultset I think. However, It is not working as desired. In the case of an empty resultset also I am getting %SQLCODE = 0 until result.%Next() is called. Also, %ROWCOUNT is giving 0 in a case where my query is return 1 result row. I am so confused about this.
while resultset.%Next() {

// code

}

Hello,

I tested the query on the Config.ConfigFile table of the Namespace %SYS, it returned 3 lines and a fatal error:

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

Hi

I am using below function and it works fine but i want to match the value ignoring the first 4 chars as they are only added to sort the data.

##class(Ens.Rule.FunctionSet).Lookup

For example

My table has following values

0001EMRNameB

0002EMRNameA

Hey Developers,

You're very welcome to check the most-watched videos for 2020 on InterSystems Developers YouTube Channel:

Hi Community!

New "Coding Talk" video is already on InterSystems Developers YouTube:

⏯ How to Install and Use ObjectScript Package Manager with InterSystems IRIS

https://www.youtube.com/embed/TBJX2kfzOc8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi Community,

It's time for the new videos from Global Summit 2019 on InterSystems Developers YouTube Channel! Are you ready?

Please welcome the first session recording from InterSystems Developers:

The State of the InterSystems Developer Community

https://www.youtube.com/embed/sTSzhETokWQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi guys!

We introduced a tag tree.

It looks like that:

Group

• Caché (4513)
• Ensemble (1122)
• DC Feedback (724)
• Announcements (666)
• Atelier (533)
• HealthShare (518)
• DeepSee (379)
• InterSystems IRIS (323)
• Online Learning (222)
• iKnow (109)
• Worldwide Response Center (WRC) (42)
• InterSystems Official (42)
• Documentation (33)
• Open Exchange (33)
• Developer Community (28)
• Global Summit (27)
• Global Masters (27)
• Other (15)
• InterSystems IRIS for Health (15)

Has anyone created Delegated Authentication using the Windows Certificate Store? Thank you for any feedback.

Introduction

In healthcare, the outcome of a life-or-death decision can depend on the available information. To help deliver the right information at the right time and place, healthcare organizations traditionally have used HL7 interface engines to share data among clinical applications.

Speeding Up Antibiotic Resistance Detection with InterSystems IRIS

Antibiotic resistance is a critical health challenge, requiring rapid detection to inform effective treatments. We worked on developing a solution that leverages InterSystems IRIS vector database technology that would quickly identify resistance genes in DNA.

The first developer preview of InterSystems IRIS 2024.3 and InterSystems IRIS for Health 2024.3 has been posted to the WRC dev

It's Friday and a long weekend is upon us, so let's have a round of code golf!

Nowadays, it's rare to find a text message without at least one emoji. 😃😄😎🙂😊😀😁😆😂
But back in the day, people had to be creative to express their emotions in text. They would use emoticons, which are symbols made up of keyboard characters :^) =] ) B).
Our challenge for today is to create a function that receives a string as argument and returns the total number of smiling faces or happy faces.
Each smiley face must have one smiling mouth, which should be marked with ), ], }, D or >.
A smiley face can have a pair of eyes but it does not have to. Valid characters for eyes are :, ;, 8, B or =.
A nose is optional, and can be represented these characters: -, ^, c, o and ~.

Valid smiley face examples:

    :) :D ;-D :~) :‑) :-] =)    
    :] :-> :> 8-) :D 8‑D )
    8) :-} :} :o) :c) :^) =]
    :‑D 8D =D B^D

Input

"count how many smiley faces are here :)"

​

Output

1