All
Accepted answers
Robert Cemper · Feb 5, 2021 go to post

the second line of the error msg tells you that SQLserver raised error 102

This error occurs when Adaptive Server detects a syntax error in a Transact-SQL® command or query. This error can occur when: A keyword is misspelled. ... You used a variable for a database name and your query contains a parser error; error 102 is raised because the batch was never executed.
from:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/CHDGFCCJ.htm
suggestion: Check the SQL-name of the generated class samples.people

Robert Cemper · Feb 5, 2021 go to post

Developing in the production environment is "high-risk extra class".
This doesn't exclude to do development on the production SERVER (e.g by lack of HW)
The most simple option is to have 3 namespaces in parallel. PRODUCTION (aka WORK), TEST, DEVELOPMENT.
A better variant is to have a 2nd instance on the same SERVER machine for  TEST & DEVELOPMENT.
Git doesn't care which Instance you use.
ZMP is not availaible in Caché.
Docker is theoretically possible but quite an effort as you need to build your own image especially for a WIN environment and get the appropriate license for it.

Robert Cemper · Feb 3, 2021 go to post 

set diff=3600   ; time in sec
set new=$zdth($zdt($h,-2)-diff,-2) ; new $h - 1 hour
Robert Cemper · Feb 2, 2021 go to post

Thank you for the link.
My urgency has changed meanwhile and I don't have access to the data source anymore. 
Nevertheless, the problem is a general one.

Robert Cemper · Feb 2, 2021 go to post

Line 1: 

<?xml version="1.0" encoding="UTF-8"?>

Check all <?   tags if they only contain ASCII characters  (no UTF yet)
Offset 106  indicates that it is rather at the end of line.
Could be some windows newline <CR><LF> instead of  Linux/Unix newline <LF> or similar

Robert Cemper · Feb 1, 2021 go to post
  • I run apt-get during development
  • I edit various files
  • and I WANT TO HAVE FULL CONTROL over my environment at any level
  • and I hate any limiting in MY code

So, what's wrong with that? 

Robert Cemper · Feb 1, 2021 go to post

irisowner just has no root access 

So i usually extend my Dockerfile this way:

ARG IMAGE=containers.intersystems.com/.......
FROM $IMAGE
USER root   
RUN echo "root:iris-2101" | chpasswd


and then with su root  I get all rights I need. 
doesn't help to limit CPUs

Robert Cemper · Feb 1, 2021 go to post

Good Old VMware Player would allow selecting processors, memory, access rights, ..
Docker is definitely no replacement to it. Just a hack.

Robert Cemper · Feb 1, 2021 go to post

You can't run a SQL statement from the console prompt.
You need to start the SQL shell first:

SAMPLES>do $system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
 
The command prefix is currently set to: <<nothing>>.
Enter <command>, 'q' to quit, '?' for help.
[SQL]SAMPLES>SELECT . . . . your statement
Robert Cemper · Jan 29, 2021 go to post

Sorry,
I probably don't understand what you try to achieve.
To my understanding ZPM is targeted to IRIS and its applications and
NOT to the underlying operating system.
- Though I admit that a lot of "hacking" into the OS is possible from IRIS. 
With the broad range of operating systems supported by IRIS, 
I rate this as a rather questionable approach, that I wouldn't support. 
 

Robert Cemper · Jan 27, 2021 go to post 
##class(Ens.Util.Time).ConvertDateTime($e(source.{ORCgrp(1).RXA:DateTimeStartofAdministratio}_"000000",1,14),"%Y%m%d%H%M%S","%d/%m/%Y",,.tSC)

should save your problem. then default time is 00:00:00

Or without any time

##class(Ens.Util.Time).ConvertDateTime($e(source.{ORCgrp(1).RXA:DateTimeStartofAdministratio},1,8),"%Y%m%d","%d/%m/%Y",,.tSC)
Robert Cemper · Jan 26, 2021 go to post

As iristrmd.exe only runs on Windows it is simply localhost:23  Telnet 
+ SMP:  System > Security Management > Services > %Service_Telnet enabled
iris session is not available in Windows

Robert Cemper · Jan 21, 2021 go to post

Right. It stands at the first line and  <ctrl>+<F5>  in Studio starts it

It is also in Debug  menu / Go 
I think that the design idea was to have a last chance to set breakpoints.

Robert Cemper · Jan 21, 2021 go to post

just tried to reproduce a similar case in Terminal.
#0) clear all stored  breakpoints (menu: Debug / View breakpoints / remove all)
#1) set the breakpoint in Studio using F9
#2) attach to process (shell if in Terminal)
#3) do ^yourroutine in terminal
#4) In Studio: <ctrl>+<F5>  let it run 
if your breakpoint is reached you see the yellow box

Hint: try it with some simple 5 line routine first

If you never see the yellow box then you just don't execute this line 

Robert Cemper · Jan 21, 2021 go to post

That's correct if you are already in an .int routine.
OTHER relates to cls, mac, ..... 

Robert Cemper · Jan 19, 2021 go to post

Ahh!
Studio debugger is based on ZBREAK command.
old style BREAK is only useful for interactive debugging in the terminal and ignored in background
I always tried not to mix it up.  Not sure if this is the reason. I think it's suspicious. 
 

Robert Cemper · Jan 19, 2021 go to post

I've seen such behavior during debugging when I fell into some deployed system code (.obj only)
A similar effect happened to me when I touched some customized command, function, variable from ZLANG***
[which I tried to debug !!!]

I could gain control again by some <SHIFT><F11>  until returning to some code covered by .int
As Studio stores a lot of info in the Windows registry just killing Studion might cause some confusion. 

Robert Cemper · Jan 14, 2021 go to post

Could you pls. be a little more precise about what you expect:
heavy & complex & simple is quite ambiguous.

Robert Cemper · Jan 14, 2021 go to post

Caché has a nice example in namespace SAMPLES how to upload a stream of any length:  
/csp/samples/upload.csp.