Article Mihoko Iijima · Sep 14, 2023 1m read

How to get all fields of a specified table with SQL

InterSystems FAQ rubric

It can be retrieved using the schema INFORMATION_SCHEMA.

INFORMATION_SCHEMA is a system schema and is not displayed by default in the SQL menu of the Management Portal.

The method to display it is as follows.

  1. Open Management Portal → System Explorer → SQL menu.
  2. Check "System" on the left of the schema drop-down.
  3. Select INFORMATION_SCHEMA from the schema dropdown.

The SQL to get the ID, field name (COLUMN_NAME), data type (DATA_TYPE), description (DESCRIPTION) for the specified table (Sample.Human) is as follows.

SELECTID,COLUMN_NAME,DATA_TYPE,DESCRIPTION
FROM INFORMAT
#Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #SQL #Tips & Tricks
0
1 678
Discussion John Murray · Sep 8, 2023

Unable to create trial deployment on Health Connect Cloud

Earlier today I enrolled at Cloud Services Portal and clicked "Start trial" for the "Health Connect Cloud" service. Next step was "Create Deployment". The only deployment size offered was "Micro", so I picked that, completed the other required details and clicked "Create".

Response was:

I reported this using the "Submit Feedback" option on the dropdown from my username in the top right of Cloud Services Portal but haven't yet received a response. Hence this DC post, in case someone here can tell me what I'm doing wrong.

#Health Connect #HealthShare #Cloud
9
0 305
Question Nezla · Sep 13, 2023

Fileupload and %OnSubmit

Hi Guys,

I've a popup zen page to upload files using the input tag and submit button as below :

<html>
<input type="file" size="80" name="FileStream" class="button" id="fileUpload" />
</html>
<!--imageclickbutton id="btnUpload" caption="Upload" width="90" height="30" onclick="zenPage.Upload();"/-->
<submit align="right" id="Submit" name="Submit" caption="Upload1" />

and the problem is that after loading the file on the %OnSubmit classmethod I need to execute a client code a Javascript clientMethod  (CloseAndRefresh()) which closes the current popup screen and refresh a gridview in Original page 

so

#Ensemble #ZEN
2
0 363
Question Scott Roth · Aug 9, 2023

How do I convert my JSON Response to an Ens.Response object with Lists of Arrays

Still working on my first External REST API call, and I am struggling to find the exact answer I am looking for... I get a JSON response from my API call but I am not quite sure how to dynamically get the JSON response into the Ens.Response Object with its lists of Arrays that I have defined.

  set tSC = ..Adapter.SendFormDataArray(.tHTTPResposne,"POST",tHTTPRequest,,,tURL)

  set pResponse = ##class(User.REST.Epic.Msg.GetPatientLocationResponse).%New()

  set dynObject = {}.%FromJSON(tHTTPResposne.Data)

  set iter = dynObject.%GetIterator()

  while iter.%GetNext(.key,.value){

    $$$TRACE("key =

#Health Connect #InterSystems IRIS #InterSystems IRIS for Health #API #JSON #REST API
10
0 735
Question Pietro Di Leo · Sep 7, 2023

Inconsistent Visual Trace Outputs

Hi everyone,

I have a question related to a strange issue I've been experiencing over the last few days.

Context

I'm attempting to create an automatic resending system that, if no reply is received from the server, raises an error and re-sends the message. This process continues for the a duration defined by the FailureTimeout (e.g., 20 seconds), and a new message is being sent every 5 seconds until the FailureTimeout is reached. If no response was obtained from the server, the system returns an error. 

Issue

I've noticed that at times, even with the same input and settings, the outputs displayed

#InterSystems IRIS
2
0 371
Question lw lw · Sep 7, 2023

Does mirroring support journal restore?

My cluster status is as follows:

when I do journal restore on primary, it says journal restore is not allowed. The DR is also not allowed to do journal restore.

1) Begin Journaling (^JRNSTART)
 2) Stop Journaling (^JRNSTOP)
 3) Switch Journal File (^JRNSWTCH)
 4) Restore Globals From Journal (^JRNRESTO)
 5) Display Journal File (^JRNDUMP)
 6) Purge Journal Files (PURGE^JOURNAL)
 7) Edit Journal Properties (^JRNOPTS)
 8) Activate or Deactivate Journal Encryption (ENCRYPT^JOURNAL())
 9) Display Journal status (Status^JOURNAL)
10) -not available-
11) -not available-
12) Journal
#InterSystems IRIS #InterSystems API Manager (IAM)
3
0 269
Discussion Sylvain Guilbaud · Sep 11, 2023

Manage SQL accesses to all or some schemas in a database, instead of managing it a the tables level.

Currently, the SQL privileges (SELECT, INSERT, UPDATE, DELETE) are managed at the tables level, which can be very tedious when you have to administer many roles in an organization, and need to keep them sync with a constantly evolving data models.
By managing privileges at the schemas level, will allow to give SELECT and other DML privileges to *all* or *several schemas* to a role|user, fixing the need to manually synchronize the new tables|views to the roles.

If you agree, I invite you to vote for this idea.

#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Security #SQL
6
0 355
Question Emil Odobasic · Sep 6, 2023

Question if it is possible to receive a REST call to an EnsLib.HTTP.InboundAdapter

Hello everyone!
I need to build something that will receive a REST request. As of now I have tried my luck with using an EnsLib.HTTP.InboundAdapter. But i am not so sure how I am supposed to configure it to be able to receive the REST request together with the JSON body.
I have specified the OnProcessInput in the adapter so that it receives a GlobalCharacterStream. However, I have not had any good luck finding out to actually make the request to the EnsLib.HTTP.InboundAdapter. 
I would be really thankful if you could let me know if it is possible for an EnsLib.HTTP.InboundAdapter to actually

#Ensemble #HealthShare #REST API
8
0 498
Discussion Luis Angel Pérez Ramos · Sep 11, 2023

What about BPL and DTL web pages automatic refresh?

I usually receive complains from our customers about the BPL and DTL web pages automatic refreshes, it's a common problem among newbies users but for veteran developers too, they forget to save the changes regularly and automatically the web page is reloaded, losing all the work done.

Maybe an autosave would fix this problem that produces a deep feeling of hate and resentment against InterSystems technology among our customers. I've added an idea in our portal, so feel free to vote it!

https://ideas.intersystems.com/ideas/DPI-I-452

#HealthShare #InterSystems IRIS #Business Process (BPL) #DTL
12
0 341
InterSystems Official Bob Kuszewski · Aug 17, 2023

InterSystems Supported Platforms Update Q3-2023

We often get questions about recent and upcoming changes to the list of platforms and frameworks that are supported by the InterSystems IRIS data platform.  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

With that said, on to the update…

IRIS Production Operating Systems and CPU Architectures

Red Hat Enterprise Linux

  • Recent Changes
    • RHEL 9.2 & RHEL 8.8 were released in May, 2023.Red Hat is planning to support these releases for 4 years.
#Caché #InterSystems IRIS #InterSystems Official
4
2 686
Question Pravin Barton · Sep 12, 2023

How to exclude folders from VS Code ObjectScript search

I have a VS Code workspace using server-side editing with separate folders for different namespaces on the instance:

{
	"folders": [
		{
			"name": "SYS",
			"uri": "isfs://server:%SYS/"
		},
		{
			"name": "cls",
			"uri": "isfs://server:USER/?filter=*.cls"
		}
	]
}


The VS Code search works well to find symbols in ObjectScript files, but it searches across all folders. Is there a way to include or exclude certain folders from the search? I've tried adding some patterns to the "files to exclude" dialog, but none of these seem to work: SYS/**, /SYS/**, %.*, \%.*

#VSCode
3
0 917
Discussion Dmitry Maslennikov · Sep 1, 2023

Data warehouses and data lakes with data from IRIS

In today's landscape, enterprises have grown substantially in scale, amassing vast amounts of data. This data is collected from a plethora of sources including different applications, databases, and other channels. Given the diversity and volume of this data, it's only logical for these enterprises to seek a deeper understanding of what their data entails. Some of the data can be stored in IRIS, and it can be reasonable to be able to add this data to a data lake too.

The Internet now offers many different tools for such tasks, that do not yet support IRIS, but it's achievable. 

What do you

#InterSystems Ideas Portal #InterSystems IRIS #Big Data #SQL
7
0 676
Question Smythe Smythee · Sep 11, 2023

How to read and write values into Ens.StreamContainer

Hi Community,

I have SDA file as Ens.StreamContainer Message using pRequest As Ens.StreamContainer

SDA file structure looks like this 

<Name><FamilyName>Lucy</FamilyName><GivenName>Hale</GivenName><MiddleName>Park</MiddleName></Name><Gender><Code>F</Code><Description>F</Description></Gender><BirthTime>2023-09-07T00:00:00</BirthTime>

How can i change individual value from the Steam and then save changed value into the stream?

#InterSystems IRIS for Health #Business Operation #DTL #XML
3
1 977
Question Robert Bielen · Aug 25, 2023

Reply Code Actions Question

Hi Everyone

I'm just wondering if anyone might have a list (or the experience to make a list) of the most often used / useful Reply Code Actions?

In the Help section of Health Connect Management Portal, it lists 

'E=F' and ':?R=RF,:?E=S,:~=S,:?A=C,:*=S,:I?=W,:T?=C'

as the default options, though I'm curious if anyone else has found other codes or strings of codes useful?

Thanks in advance. 

Best wishes

Robert

#Health Connect #InterSystems IRIS for Health #Management Portal #System Administration
3
0 722
Question Dmitry Maslennikov · May 15, 2023

What happened to compilation log?

How to understand what's wrong with compilation if the compilator just hides errors?

Compilation started on 05/15/2023 15:58:11 with qualifiers 'cuk'

Detected 1 errors during compilation in 0.003s.


Compilation started on 05/15/2023 15:58:32 with qualifiers 'cuk'

Detected 1 errors during compilation in 0.002s.


Compilation started on 05/15/2023 15:58:51 with qualifiers 'cuk'

Detected 40 errors during compilation in 0.089s.

 

40 errors, and what do I have to do with this so valuable information?

#InterSystems IRIS #Compiler
10
0 434
Question Sandeep K C · Sep 7, 2023

start/stop systemd httpd service in mirror servers

Hello Everyone,

We currently have CSP application that runs under 2 servers(usually primary), and every month the server reboots for patching SERVER1(primary) in the morning and SERVER2(backup) at night.

Whenever the SERVER1 reboots SERVER2 behaves as primary and when SERVER1 comes back up it will act as backup server.

First Patching:

So, when SERVER1 is down, I need to start httpd service for SERVER2 and stop httpd service for SERVER1 (which is now backup server).

I tried using the code below in terminal to start httpd service for SERVER2 with no success.

// Need to provide password for current
#Caché #Application Server #Authentication #Backup #Failover #Mirroring #Terminal
5
0 369
Question Thiago Andrade · Nov 3, 2021

ISCLOG Error

I received an ISCLOG errors in my IRIS container, and the processing is very slow because of that. How to solve this problem?

[Utility.Event] ISCLOG: SuperServer Super Server job slave failure ns=%SYS rtn=%SYS.SERVER
[Utility.Event] SuperServer failed to start slave server
 

#InterSystems IRIS
4
1 1340
Question Parameshwaran Muthaiyan · Sep 8, 2023

Using an enum in the entity class not creating the table via Quarkus

This question originally appeared in the comments of the post: Using the new InterSystems IRIS Hibernate 6 Dialect for a Springboot Project
 

Hello @Yuri Marx 
greetings for the day!
I am unable to fix this issue (using an enum in the entity class; it's not creating the table).I have using your dialect foder, but I am facing this issue.In I was searching on the website all of them are using Quarkus versions below 3, and the InterSystems jar version is 3.3.0.No one can use Quarkus version 3, and no one has published a suitable dialect for Quarkus 3.

#InterSystems IRIS #Java
4
0 497