On Windows, run the lines in a cmd window. The first can be run without modification, but to run the second line use this escaping:
The In() function in Ens.Util.FunctionSet is documented as searching for a value in a comma-delimited string.
There is undocumented additional functionality for custom separators.
If the items parameter has ",," (two commas) right before the last or second to last character in the string, then the following strings are used as separators.
If there is one character, then that is used as a separator:
w ##class(Ens.Util.FunctionSet).In("a","|a|f|d|c|a,b|a,b,c|,,|")
1
If there are two characters, then those are used as a prefix and suffix for values:
w ##class(Ens.Util.FunctionSet).In("a","<a><b><c><a,b,c>,,<>")
1
Please note that although there is an intention to document this in a future release at some stage, as it is not documented at the moment, it should be used with extreme caution - it may be removed from future versions without warning.
The IRIS 2022.3 documentation has this:
ODBC drivers are available for download from the InterSystems Components Distribution page here: https://wrc.intersystems.com/wrc/coDistGen.csp
There is a tool ("ompare") on the InterSystems Open Exchange for comparing environments. You might find that it does a lot of what you need.
https://openexchange.intersystems.com/package/ompare
(The author is @Alex Woodhead )
You'll need to do the ReadLine() just once in each iteration of the loop so that you don't get the P1 from one line pairing with the P2 from the next line, something like this:
set file=##class(%Stream.FileCharacter).%New()
do file.LinkToFile("c:\location of csv")
for quit:file.AtEnd set line=file.ReadLine()set ^GLOBAL($piece(line,",",1),$piece(line,",",*))=""
Or
USER>k temp set $LIST(temp,31)="",myVar=$LISTTOSTRING(temp,"=?",1) USER>w myVar =?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?=?
The online documentation is here:
There is some training in the InterSystems Learning portal (you'll need to enrol/login):
e.g.
You need to kill the pars parameter array and recreate it each time you use it. This is mentioned in the documentation:
https://docs.intersystems.com/csp/docbook/DocBook.UI.Page.cls?KEY=ESQL_parameter_overview
Important:
If you execute multiple queries that use the parameter array, kill and recreate the parameter array before each query.
You mentioned that you ran setup.py, but you are running Python version 3.6.0.
I believe setup.py is the install for Python 2. Have you also tried running setup3.py? i.e.