Posts by Tom Bruce on InterSystems Developer Community

Question

Tom Bruce · Jun 20, 2022

Hi, I tried the following exercise from the IRIS documentation. I updated the username, password and IP address, but receiving this error;

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. --->

I can use the same credentials and IP address to connect ok via VSCode to my local IRIS...

Any pointers much appreciated.

#.NET #ObjectScript #InterSystems IRIS

0 3

0 367

Question

Tom Bruce · Jun 13, 2022

Get filename and path

Hi, is there a method that can retrieve both the filename and archive path?

#ObjectScript #InterSystems IRIS

0 1

0 433

Question

Tom Bruce · May 30, 2022

Test if a dynamic query returns 0 results

Hi, what’s the best way to check if your query return 0 records?

#ObjectScript #SQL #InterSystems IRIS

0 1

0 331

Question

Tom Bruce · Apr 26, 2022

HOW ALTER PRIMARY KEY

Hi everyone,

How do you alter primary key on a table that has data?

Any example much appreciated.

Cheers,

Tom

#Databases #Data Import and Export #SQL #InterSystems IRIS

0 1

0 277

Question

Tom Bruce · Apr 25, 2022

Run multiple Update sql queries

Hi everyone, how do you run multiple quires?

I have tried couple of different ways, but not working.

SET sql = 2

Set sql(1) = "UPDATE QUERY"

Set sql(2) = "UPDATE QUERY"

Set sqlStatement=##class(%SQL.Statement).%New()

Set sc1=sqlStatement.%Prepare(.sql)

If $$$ISOK(sc1) {

Set tResult = sqlStatement.%Execute()

}

else{

$$$LOGERROR("Failed")

}

#ObjectScript #SQL #InterSystems IRIS

0 4

0 1.6K

Question

Tom Bruce · Mar 30, 2022

How do I return YYYYMMDDHHMM

Hi, I’m using $ZDATETIME to return the following

#ObjectScript #InterSystems IRIS

0 4

0 303

Question

Tom Bruce · Feb 24, 2022

Mutual Authentication

Can an IRIS RESTful api implement mutual authentication?

If so, can you point me to the documentation.

Thanks

#API #InterSystems IRIS

0 1

0 325

Question

Tom Bruce · Jun 18, 2020

inbound file service picks up low & high case files with a wildcard?

Hi, what’s the syntax for picking up low/high cases?

#Business Service #Ensemble

0 2

1 321