Syndicate content 0  
 
All time
Question
· Jan 14, 2025
INSERT OR UPDATE WITH A COUNTER

Hello,

So i want to use the INSERT OR UPDATE command so i can update a COUNTER for a given name:

INSERT OR UPDATE myTable
SET name='Omer', counter = counter + 1;


as you can see with the above code - if the row is non-existent then we get an error because COUNTER is NULL!
I tried the following to fix this but all have failed:

3 26
0 357
Article
· May 30, 2024 1m read
How to avoid ODBC query timeouts

InterSystems FAQ rubric

To disable the timeout, set the query timeout to disabled in the DSN settings:

Windows Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN configuration

If you check Disable query timeout, the timeout will be disabled.

If you want to change it on the application side, you can set it at the ODBC API level.

Set the SQL_ATTR_QUERY_TIMEOUT attribute when calling the ODBC SQLSetStmtAttr function before connecting to the data source.

2 0
0 383

I need to verify that certain .m files have been compiled and inserted into the VA mumps database. I need to do it on a schedule and thus I want to automate it. Because of the automation I'd prefer not to use the IRIS web app. So if there were a similar CLI version that would be great. I see there is something called /usr/bin/iris but this seems to be a maintenance tool, not a IRIS.DAT querying tool. I'd love to be wrong about that.

Please forgive my lack of proper nomenclature, clearly I'm a n00b.

1 6
0 377
InterSystems Official
· Apr 3, 2023
IAM 3.2 Release Announcement

IAM 3.2 Release

InterSystems API Manager (IAM) version 3.2.1 is now Generally Available. In additional to bug fixes and minor improvements IAM 3.2 adds new plug-ins that might be of interest to IRIS customers.

  • OAS Validation (oas-validation)
    • Validate HTTP requests and responses based on an OpenAPI 3.0 or Swagger API Specification.
  • SAML (saml)
    • Provides SAML v2.0 authentication and authorization between a service provider (Kong Gateway) and an identity provider (IdP).
  • XML Threat Protection (xml-threat-protection)
    • This new plugin allows you to reduce the risk of XML attacks by checking the structure of XML payloads. This validates maximum complexity (depth of the tree), maximum size of elements and attributes.
  • AppDynamics (app-dynamics)
    • Integrate Kong Gateway with the AppDynamics APM Platform.
  • JWE Decrypt (jwe-decrypt)
    • Allows you to decrypt an inbound token (JWE) in a request.

4 0
0 383

Dear Experts,

I have to pull out a report of certain code tables and this is my first script and I need to write many.

1. If I have to refer to the table, seeing the reference in the components with reference to SQL table and column,

can I use Select < What I need from the table>

Inner join with reference table?

I tried, I used the code table reference in the components, but I am getting errors,

0 3
1 380

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Machine Learning with IntegratedML & Data Robot

https://www.youtube.com/embed/BRyWD39Sado
[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]

2 0
0 383

Hey Developers,

Please welcome the new video on InterSystems Developers YouTube:

⏯ System Alerting & Monitoring

https://www.youtube.com/embed/EYLHIEAxHLk
[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]

3 0
1 383

Hi, I have installed IRIS community version in my laptop which has Windows 10 OS, also I am already using Healthshare (Cache for Windows (x86-64) 2017.2.1 (Build 801_3_18178U)) in the same laptop. I tried to import objectscript package manager XML file which is downloaded from https://pm.community.intersystems.com/packages/zpm/latest/installer . I am getting below output which installation failed. Please help to fix this. Thanks in advance

0 5
0 378
Question
· Oct 1, 2019
Atelier: Install

I've installed Atelier according to instructions but after rebooting Eclipse there is not opportunity to launch Atelier. In preferences there is not Atelier. I've tried to update and reinstall Atelier but it didn't get a result. I checked it was installed on my PC.

How can I solve this problem? And why I faced to this situation?

All needed components were been installed earlier.

0 2
0 381

Hi, Community!

Check a new session recording from Global Summit 2017:

iKnow What You'll Do Next Summer

https://www.youtube.com/embed/7Y5mdY3M3vo
[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]

1 0
0 383

I am in Atelier editing a Class.

I want to look at the window or pane that shows my Properties,

I get to the tab that show Properties and their Value as shown below.

Now, how do I get the properties from my Class into the image below?

0 2
0 381
Question
· Jul 20, 2017
Cursor placement

Greetings,

What methods are available to position a cursor on a screen to begin writing as not to disrupt other areas of the screen? I have used ?# , ie: ?5 but this is destructive from the let to character 5. I would like to enter a command that will position at row,col and then start writing? Can I create a window in a window type display to write text and then when done viewing, remove it?

Please advise,

Thanks in advance for everyone's time.

0 2
0 381

IO devices can be assigned to a mnemonic space using, for example:

u device::"^%X364"

Is there a method that will return the assigned mnemonic space for the current device?

I can infer it by attempting to write to the device using a non existent write /mnemonic and then inspecting the error returned, but this is rather messy and could potentially affect the status of the device. For example:

0 2
0 381
Question
· Mar 29, 2016
I/O Logged messages question

Hi -

I was looking at the “Purge Data Management” page, and one of the “Record Types” is the “I/O Log” which sometimes doesn’t clear when you purge all of the message.

But I’m not sure what it’s actually reporting as “I/O Log” messages (and I can’t find anyplace to view what is being considered I/O Logged Messages - so I can understand what’s happening)

Can anyone shed some light on these messages?

0 1
0 382