How can I translate this Excel macro to PxPlus?

function main(workbook: ExcelScript.Workbook) {
let sheet1 = workbook.getWorksheet("sheet1");
// Add a new table at range A1:L10 on sheet1
let newTable = workbook.addTable(sheet1.getRange("A1:L10"), true);
}


Using try-catch allows us to continue program execution but it doesn't provide any useful information about the reason for the exception.

Please take a look at my sample code
begin
try
call pgn+";LABEL1"
catch
print err, " ", err("stno"), " ", err("program")
print "--- error history ---"
maxIndex = prm('EH')
for local i = 1 to maxIndex
print str(i : "##0"),": ", err("err", i, err = *break), " ", err("program", i), " ", err("stno", i)
next
end_try
print "End"
end
LABEL1:
call pgn+";LABEL2"
exit
LABEL2:
call pgn+";LABEL3"
exit
LABEL3:
string2Convert$ = "not a number"
numValue        = num(string2Convert$)
exit

I think it is challenging to provide a complete dump at the point where the error occurs. But it should be possible to provide a small dump of all the variables used in the error statement. That dump could be provided by a new keyword, e.g. err("DUMP").
The information will allow us to find the reason for the exception and apply proper corrections.

We want to disable variables by globbing patterns and by using a generic approach.

suggestions:
dumb disable "%param_*"
dumb disable via varName$

In our application we create a lot of global parameter variables, which don't need to be part of a dump.
Globbing patterns and generics would allow us to exclude these and all nomads variables.

Solved!
As usual there have been SEPs inside my bodytext. Replacing them with $0A$ solved the prblem.

I tried ?P, ?Q, ?B and no forced encoding. The txt attachment was never received.
I checked that with the GMX app, GMX webpage and our Outlook client.
Outlook creates the ATT00001.htm attachment and GMX appends that content to the bodytext. Both destroy our company information at the end of the mail.

I can't manage to sent a txt-file as an attachment with *web/email (PxPlus 20.10).
The mail doesn't contain the originally attached file. Instead of this there is an attachment called ATT00001.htm containing the body text. I tried to force BASE64 encoding with the ?B suffix, but that didn't change anything. Other file types like png, xlsx, csv and pdf work fine.
*web/webserv.mim contains text/plain. That seems to be correct.
What am I doing wrong?

*web/email works for me. Thank you Mike.
But I have an issue with text attachments. I will start a new thread for that.

That change has no effect. After sending the secure option I cannot read the answers from the server any more. It accepts everything I send, but does nothing.
Is there a sample code showing a successful change to a secure connection and what needs to be send next in case of smtp?

That sounds so easy, but I can't get it working 
I post my sample program below. After 'option'("Secure","") nothing useful is happening any more. I tried many different things and combinations but the program can never send the second EHLO. All I received where many errors 2 or 3 or 11.

begin
delay = 3
eol$ = $0D0A$
channel = hfn
open (channel, err = FINISH) "[tcp]smtp.office365.com;587;TLS1.3;CERTIFICATES=IGNORE"
gosub GET_RESPONSE
write record (channel) "EHLO " + nid + eol$
gosub GET_RESPONSE
write record (channel) "STARTTLS" + eol$
gosub GET_RESPONSE
write record (channel) 'option'("Secure", $$) + eol$
gosub GET_RESPONSE
!write record (channel) 'option'("TLS", $$) + eol$
!gosub GET_RESPONSE
write record (channel) "EHLO " + nid + eol$
gosub GET_RESPONSE
FINISH:
write record  (channel,err=*next) "quit" + eol$
close (channel)
end
GET_RESPONSE:
read record (channel, tim = delay, err = FINISH) response$
print str(++i:"#0: "),response$
wait 0
return


We use an own implementation of SMTP if the user runs a mail server on his own.
This doesn't work with the MS server, as it requires TLS.
What is best practice for using that server from a Linux host?

I receive an error 15 with

select count(distinct columnName) from table

msg(-1)=37000: [PxPlus][SQL ODBC Driver]Expected lexical element not found: <identifier>

How can I count distinct column values using ODBC 7.0.3?

This is a WindX session and the security options are properly set.
The error occures at random. But how can that be? The file has just been created, so PxPlus must be able to open it.

I don't understand why the code below throws an err 61 sometimes


BUSY_FILE_NAME$ = "[lcl]Busy.txt"
serial BUSY_FILE_NAME$, err = *next
if tcb(2) {
rem in case the file could not be created ...
} else {
busyFile = hfn
open lock (busyFile) BUSY_FILE_NAME$
rem this throws error 61 ???
}


Are there any new insights?

The customer uses openSUSE Leap 15.5
We use a Gentoo and can reproduce the issue