All time
InterSystems Developer Community is a community of 23,216 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality.

It is recommended to go through LOAD DATA documentation first.

After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table


Below is the basic command when table is already created and source file does not contain header row. 

LOAD DATA FROM FILE 'C://TEMP/mydata.txt' 
INTO MyTable

The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns.

Loading from File Source: Header

Open Exchange app
3 1
0 304

Hi Community,

New video is already on InterSystems Developers YouTube:

⏯ Updates on Security: OpenSSL and a New "Security" Database

https://www.youtube.com/embed/Eb5kPw8-l08
[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
0 324

Hello, community!

I've stumbled on some unexpected behavior, and decided to check with you if this is normal. Basically, I'm rebuilding indices and the result is not journaling (which leads to missing indices at shadow server).

The $ZV is "Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2015.2.1 (Build 705U) Mon Aug 31 2015 16:53:38 EDT"

I have an example class 

Class tmp.A As %Persistent;

Index IP1 On P1;

Property P1 As %String;

for example there is one object which have P1 = 1, so

0 1
0 323

On a system I have been working there are some custom special variables like

do $example.DoSomething()

Some code requires a

set x=$example.SomeProperty

call e.g.

My problem is that atelier doensn't seem to be able to properly recognize this code.

0 5
0 319
Article
· Sep 28, 2015 1m read
BPL TechFAQ

The Business Processing Language - for orchestration and long-running business processes.

Ensemble can orchestrate calls to external systems. Very often this is done to implement or automate a long-running business process - that is, real business processes where people interact with a series of different systems to complete complex tasks. BPL (the Business Processing Language) provides a graphical way to create these orchestrations.

0 0
0 324

Hello,

In response to the infrastructure needs of our company's service, I've created a small API that sends SNMP queries to InterSystems to visualize relevant data for retrieval when the infrastructure implements monitoring.

However, I'm experiencing a timeout issue when attempting to collect information using an SNMP walk. Here is the code for my API's SNMP service:

0 1
0 322

Hi everybody!

Many developers prefer a dark version of applications. Not surprisingly, @Guillaume Rongier posted an idea of making a dark version for the Developer Community.

So we look forward to hearing from you.

Please send us your feedback by using this Poll on the Ideas Portal, and by voting and commenting on the relevant idea.

Thank you in advance for your votes and have a good day!

5 6
0 317

It's time to announce the Winners for February! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in February:

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia
🥈 @Heloisa Ramalho, Software Developer in the Application Services, InterSystems, USA
🥉 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

Learn more about the competition and our awesome winners below.

8 1
1 303
Question
· Aug 9, 2022
Comparisons in DTLs

Is there a way to compare the value in a source field against all of the values in a repeating field? For example, we have multiple DG1 target segments populated. Is there an easy way to check a source DG1 segments against all of the target DG1 segments? I didn't know if there is a wild card I can use for the comparison.

0 1
0 322

Trying to map two repeatable fields from a record mapper. The fields are separated by a ^. I've tried a fore each, but still getting an error when testing in the transform.

ERROR #5002: Cache error: <UNDEFINED>XMLLOOP2+414^BHS.RecordMap.PenradConvPath.Record.1 *%SAX("1",23)
0 1
0 322

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ iKnow: Open Source NLP in InterSystems IRIS

https://www.youtube.com/embed/n-TL_Wh7Tv4
[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
1 323

Hi All,

We have few queries which are simple selects . For simplicity let's say there is a query that joins two tables and gets few columns and both tables have no indexes.

Select Tab1.Field1, Tab2.Field2
From Table1 Tab1
Join Table2 Tab2
On Tab2.FK = Tab1.PK

When we do query plan for this it shows approx 6 million, however if we make a simple adjustment to the query

0 5
0 318

Wondering if there is a limit on max number of rules you can have in a single router? For outbound ADT we are approaching 60. From performance standpoint is it worthwhile to create a new router component and the service sending the same inbound message to 2 processes?

0 4
0 319

Hi All,

I have a class method, this can be any cache expression to execute (usually a class / method and args) and and args stored in a variable, for example;

set aa = "##Class(Utils.Test).Run(1,2,3)"

do aa

I tried using $classmethod(class,method,args..), by extracting the values but sometimes there can be no arguments, or arguments such as ;

("2019-01-01","1,2,3,4")

which causes issues while running the $classmethod, (i am using $P to extract the Class, Method and args).

Is there any simpler way of doing this?

0 4
0 319

Hi Community!

New video is already on InterSystems Developers YouTube Channel:

Leverage Your Users for UI Design

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

0 0
0 323