NewBie's Corner Session 12 Do and Goto

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

InterSystems Caché provides a GUI (Graphical User Interface) based Integrated Development Environment (IDE) called Caché Studio. Developers can use Studio to create and maintain applications.

Controlling Process Flow

Controlling Process Flow means controlling the execution path of code. The execution of code flows from the top to the bottom in a routine, except for the following:

Welcome to the July'23 Developer Community Release!

We're excited to share with you the latest improvements we've made to the usability of the Developer Community:

📌 Trending posts

📌 New notifications UI/UX

📌 Certified Members filter

Let's have a closer look at all these updates.

InterSystems has corrected a defect that can cause an SQL query to return incorrect results.

Hi, I cannot compile my files and the errors is not logged into output channel. Help please!

Hey Developers,

Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container:

⏯ InterSystems IRIS Container Updates

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

I have a %Time filed with (Format=1) to allow showing hh.mm.ss and the field is showing fine in display mode eg:

it should show 00:07:30 but the seconds are cut off from it as below :

I want to switch between different DSNs in business operations to query different servers, but the DO ..Adapter.DSNSet("DSNName") code will report a 15-second connection timeout error when switching DSNs. What should I do?

Hello everyone,

I have a question, I am trying to use xecute command, but something wrong happen when i was using the command, and i don't know why hahahaha.

I created a file .mac with this code:

label(test) public{
       set routine="variable"
       set call="write routine,!"
       xecute call
       quit
}

But when i run the command, show me this message error:

<UNDEFINED>label+3^tstFJR3 *routine

After that i changed the code to:

Hi everyone,

I'm creating something to test the Analytics capabilities.

I have a table with 100k records. Consulting the data using ^%G or SELECT, everything is working fine.

But, when I create a Cube using this same class as Source, the Build results in only 1 fact.

I would like to know if anyone else faces the same situation before and have some guidance.

Some details:

Hi developers!

We are starting InterSystems AI Programming Contest next week, and according to the rules, you can include some technology IRIS Features into your solutions, which will give you extra points in the voting.

Here are the technology bonuses for InterSystems AI Programming Contest!

1. IntegratedML usage - 2 expert vote points

IntegratedML is a new technology Introduced in InterSystems IRIS which you can use with InterSystems IRIS 2020.2 Advanced Analytics Preview release. IntegratedML:

• Gives users the ability to create, train, and deploy powerful models from simple SQL syntax without requiring data scientists.
• Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot.
• Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications.

Learn more in IntegratedML Resource Guide.

You can use with IntegratedML template.

2. Python Gateway usage - 1 expert vote point

Python Gateway is an addon to InterSystems IRIS which gives you the way to use Python in InterSystems IRIS environment:

• Execute arbitrary Python code.
• Seamlessly transfer data from InterSystems IRIS into Python.
• Build intelligent Interoperability business processes with Python Interoperability Adapter.
• Save, examine, modify and restore Python context from InterSystems IRIS.

Learn more about Python Gateway.

You can use the Python Gateway template, which includes IntegratedML too.

3. Docker container - 1 expert vote point

The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container.

Both templates, IntegratedML template and Python Gateway template use docker so you can collect this bonus if you build your solution using these templates.

Or you can use any other Docker-based templates, published on Open Exchange.

Feel free to ask any questions about using the listed technologies.

Good luck in the competition!

I have a simple python script to pull table information from cache 2018.1.2 which is on a windows 10 machine. I get no results though the same query in the management portal works correctly:

import os
import sys
import intersys.pythonbind3 as ipyb
import numpy as np

# Connect to the Cache' database
url = "localhost[1972]:%SYS"
user = "xxxx"
password = "zzzzz"

accessKey = (url, user, password)

def main(accessKey):

I use the 2012 version of the caché, and I need to export data in an Excel file, the point that seems to complicate is to use the dropdown list in the cell and then trigger a validation if I exceed an interval of two values.

Help me, by your seggestions, solutions
Thank you

Good afternoon, I have a tabGroup where I populate tabs with images using the scr property. If a user scrolls to the bottom of the image on a tab, when they go to the next tab, they are also at the bottom. When moving between tabs, I would like the user to always be presented with the top of the tab content. I have not been unsuccessful in doing this. Would someone have input on how to make this happen? Thank you in advance for any and all feedback.