All
Accepted answers
Phillip Wu · Jul 23, 2025 go to post

Thanks for the info.

However for "roles" SQL gives different information to that from ObjectScript:

 select * from Security.Roles

ID

Description

GrantedRoles  

Name    

NameLowerCase  

Version

However,

%SYS>Set status = ##class(Security.Roles).Get("anyrole",.properties)

%SYS>write status
1
%SYS>zwrite properties
properties("Description")="Super User Role"
properties("GrantedRoles")="NormalUserRole"
properties("Resources")="%DB_IRISSYS:R,%Service_CacheDirect:U,%Service_Object:U,%Service_WebGateway:U,%System_CallOut:U"
Why is that?

Phillip Wu · Jul 21, 2025 go to post

I found out the problem.
The Linux permissions were wrong on IRIS.DAT file

Phillip Wu · Jun 19, 2025 go to post

Can you please explain what this code does?

If I run:

DO ##class(%SYS.Namespace).ListAll(.result)
zwrite result

I get:
result("%SYS")=""
result("USER")=""

....
So how does this code work?

if $d(^|"%SYS"|CONFIG("Namespaces"," "))

for set ns=$o(@$ZR) quit:ns="" write ns,!

Phillip Wu · Jun 19, 2025 go to post

In reference to your ObjectScript code when I try to get the databases contained  in namespace "USER":
SET status = ##CLASS(%SYS.Namespace).Databases("USER",.dbInfo)
^
<METHOD DOES NOT EXIST> *Databases,%SYS.Namespace
Please advise

Phillip Wu · Apr 1, 2025 go to post

Sorry left out the variable 'Status'

select Name,Status,TaskClass,Suspended from %SYS.Task where Status <> 1

Phillip Wu · Apr 1, 2025 go to post

Would this SQL be more accurate?
select Name,Status,TaskClass,Suspended from %SYS.Task <> 1
If not, why?

Phillip Wu · Mar 5, 2025 go to post

Thanks for your advice.
I'll check out if I can get the source for the INT program

Phillip Wu · Mar 2, 2025 go to post

Thanks for everyone's suggestions.

Using the OS to pipe in the input from a file is a bit cumbersome and inflexible.
 

Phillip Wu · Feb 26, 2025 go to post

Thanks for this code.

However when I try to compile the code I get errors with the "labels"

Loading file redirectio.cls as udl
Compiling class utility.redirectio
Compiling routine utility.redirectio.1
ERROR: utility.redirectio.cls(Test+31) #1026: Invalid command : 'rchr(time)' : Offset:6 [zTest+25^utility.redirectio.1]
 TEXT:   rchr(time)  quit "a"
ERROR: utility.redirectio.cls(Test+33) #1026: Invalid command : 'rstr(len,time)' : Offset:6 [zTest+27^utility.redirectio.1]
 TEXT:   rstr(len,time) quit "xyz"
ERROR: utility.redirectio.cls(Test+35) #1026: Invalid command : 'wchr(s)' : Offset:6 [zTest+29^utility.redirectio.1]
 TEXT:   wchr(s)      do output($char(s))  quit
ERROR: utility.redirectio.cls(Test+37) #1026: Invalid command : 'wff()' : Offset:5 [zTest+31^utility.redirectio.1]
 TEXT:   wff()        do output($char(12))  quit
ERROR: utility.redirectio.cls(Test+39) #1026: Invalid command : 'wnl()' : Offset:5 [zTest+33^utility.redirectio.1]
 TEXT:   wnl()        do output($char(13,10))  quit
ERROR: utility.redirectio.cls(Test+41) #1026: Invalid command : 'wstr(s)' : Offset:6 [zTest+35^utility.redirectio.1]
 TEXT:   wstr(s)      do output(s)  quit
ERROR: utility.redirectio.cls(Test+43) #1026: Invalid command : 'wtab(s)' : Offset:6 [zTest+37^utility.redirectio.1]
 TEXT:   wtab(s)      do output($char(9))  quit
ERROR: utility.redirectio.cls(Test+46) #1026: Invalid command : 'output(s)' : Offset:8 [zTest+40^utility.redirectio.1]
 TEXT:   output(s)    set str=str_s   quit
Detected 8 errors during load.

How can this be fixed?

Phillip Wu · Feb 10, 2025 go to post

If I understand this correctly, if I want to define a new backup task called bt1:
set bt=##class(Backup.Task).%New('bt1')

Then I can get the properties:
 

w bt.LastRunStatus

w bt.Name
bt1
Is this correct?

Phillip Wu · Feb 3, 2025 go to post

Thanks to everyone for the quick replies.

Much appreciated the Python solution to the question

Phillip Wu · Jan 22, 2025 go to post

Thanks for everyone's suggestions.
Veeam after calling the 'freeze' script was doing some unnecessary processing so delaying the VMWare snapshot and the subsequent call to 'thaw' script.

Phillip Wu · Jan 21, 2025 go to post

Thanks. That seems to have done the trick.
pri_ref.value
has
'\x1c\x01SERVERA.FOO.BAR.ORG/STAGE\x14\x01SERVERA.foo.bar.org|2188\t\x01Primary\x08\x01Active\x15\x01172.31.33.69|1972\x15\x01SERVERA.foo.bar.org|1972'

The field separator appears to be \x01. However there is smattering of 
\x1c
\x14
\t
\x08
\x15

Not sure why there are these hex characters?

Phillip Wu · Jun 26, 2024 go to post

Thanks to all.
I have used the copy all IRIS.DAT files on production to test.

The only gotcha is that production the files are from a mirrored system and test is not mirrored so I needed to clear the mirror flags! 

Phillip Wu · Mar 30, 2024 go to post

Thanks.
Would I put this put it into my DB using VS CODE using the same procedure as putting a class [as shown in the youtube videos]?

Phillip Wu · Jan 18, 2024 go to post

Thanks.

I was hoping for a quicker way to do what I was doing already!

Phillip Wu · Jan 14, 2024 go to post

Thanks for that detailed answer.

My situation is slightly different.

My client is a PC running Windows 10.

My server running IRIS is a Linux SUSE 15 VM.
iristerm will be running on my Windows 10 PC and connecting to IRIS on a Linux box.
I'm not sure that the iristerm(only available for Windows) can support ssh with certificates.