go to post Robert Cemper · Feb 19, 2021 So, as by docs. SQLCODE=100 indicates that the SQL operation was successful,but found no data to act upon https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=RERR_sql#RERR_sql_noerr
go to post Robert Cemper · Feb 18, 2021 There is my example in OEX: Light weight EXCEL download if you omit the special setting of type, it is a normal html table.
go to post Robert Cemper · Feb 18, 2021 What I asked for: In your Method written in Objectscript, after &sql(update X_X.X set LocalEnvironment=1 where %ConfigName IN('X_X_X', 'Y_Y_Y')) Variable SQLCODE holds a success / failure code. That's what I asked for.see this example: https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GSQL_esql#GSQL_esql_syntax_ampsqlor https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GSQL_esql#GSQL_esql_code_literalsandhttps://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=RERR_sql#RERR_C136606
go to post Robert Cemper · Feb 18, 2021 You may stick with '/' and run $TRANSLATE(record,"/","~") just before writing the record to your file.DAT
go to post Robert Cemper · Feb 18, 2021 did you try ! or ? instead of ~ since ~ might be a reserved default separator to HL7
go to post Robert Cemper · Feb 18, 2021 What does SQLCODE tell you after your embedded SQL query?What is your real $ZV ?
go to post Robert Cemper · Feb 12, 2021 @Daniel Tamajon I'm using GitHub in browse to create this project. https://github.com/rcemper/try_embedded_pythonHow is the quality check started / triggered ? Is some minutes > 20 minutes ?
go to post Robert Cemper · Feb 8, 2021 I was searching this but looked for ManagerDirectory instead of InstallDirectory
go to post Robert Cemper · Feb 8, 2021 write $replace(##class(%File).ManagerDirectory(),"mgr","lib") independent of OS!
go to post Robert Cemper · Feb 8, 2021 All %R* routines are hidden in IRIS for good reasons.And they just survived for backward compatibility not for common use.And they use ZS ZI, ... and $Compile() function. ... and a bunch of $ZU(..) Manipulating routines from Terminal is not covered. VScode or Studio is expected and supported
go to post Robert Cemper · Feb 8, 2021 If you edit .INT routines from the terminal in the old MUMPS style using ZLOAD, ZSAVE, edit by X ^%you operate at a lower level than Studio, VScode, Atelier,... and deeper than any Source Control Hooks. Neither belt nor suspenders are available anymore. It's like heart surgery: Either you fix it or your patient is gone.
go to post Robert Cemper · Feb 5, 2021 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.htmsuggestion: Check the SQL-name of the generated class samples.people
go to post Robert Cemper · Feb 5, 2021 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.
go to post Robert Cemper · Feb 3, 2021 set diff=3600 ; time in secset new=$zdth($zdt($h,-2)-diff,-2) ; new $h - 1 hour
go to post Robert Cemper · Feb 2, 2021 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.
