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,",",*))=""
go to post
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:
do file.LinkToFile("c:\location of csv")
for quit:file.AtEnd set line=file.ReadLine() set ^GLOBAL($piece(line,",",1),$piece(line,",",*))=""
go to post
Or
go to post
Many command line utilities are listed and documented in the legacy documentation:
https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GDOC_legacy
go to post
The online documentation is here:
There is some training in the InterSystems Learning portal (you'll need to enrol/login):
e.g.
go to post
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
go to post
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.