PxPlus uses the standard Windows scrollbars. So how they look is largely up to Windows. With Windows 11 they seems to hide the arrows indicating the buttons unless you mouse over them.

A spinner control is just a multi-line with a scrollbar where you just see the buttons. If on Win 11 you only see the buttons when hovered over. I don't think the auto hide setting will have any effect as the scrollbar PxPlus generates for the spinner control aren't hidden it is only the arrows.

A quick look and it doesn't seem Windows 11 allows you to control this behavior of the standard scrollbar.

Something we are considering for a future version of PxPlus is to enhance the spinner control giving developers more control over how it looks. This would mean not using the standard windows scrollbar and getting this auto hide arrows behavior.

PxPlus has a [DB2] interface similar to the ODBC interface (https://manual.pvxplus.com?command_tags/db2.htm).

Note:
To use the DB2 interface, you must have either the DB2 database or the DB2 client installed on a workstation, and the path to the db2cli.dll file must be locatable by the PATH environment variable.
When using the DB2 client, a db2cli.ini file is created in the user directory to specify such parameters as the Hostname (address), uid (user) and pwd (password).

You can try this to see if it is any faster for you compared to ODBC.

Note the performance may have more to do with the SQL generated then which interface is used. PxPlus will convert reads and writes to SQL for you but in order for it to do that it has to generate SQL that will work for all types of reads and writes. This means it doesn't always generate the most efficient SQL.  You can however issue SQL directly and read the results allowing you to craft the most efficient SQL for the data you need (https://manual.pvxplus.com?PxPlus%20User%20Guide/Data%20Integration/Introduction%20to%20SQL/Using%20SQL%20Directly%20Within%20PxPlus.htm).

Unfortunately Composite strings cannot be used as object properties (See the note here: https://manual.pvxplus.com?directives/dim.htm#Mark7).

You can probably accomplish what you are going for by dynamically creating properties (https://manual.pvxplus.com?directives/def_class.htm#dynamic).

You said:

Actually, I had to make some adjustments, since it always added ";secure" to the OPEN, and that generated a PxPlus error.

*plus/web/request is adding the ;secure to the open because it is a HTTPS server. If you modified the program not to do that then it then likely the server rejects the request since it is insecure.

What error where you getting when it did add the ;secure? It is possible OpenSSL is not setup correctly for PxPlus to find it and fixing that will resolve your issue.

How to fix missing OpenSSL Libraries on Linux: https://forum1.pvxplus.com/index.php?topic=495.0

If your Linux distribution is older it also could be possible it doesn't support the minimum SSL/TLS version required by the server you are trying to connect to.

The error message when you attempt with a ;secure should tell you what the issue is.  You may need to print msg(-1) for more info.

the \K is an argument to the cmd.exe program

The COMSPEC environment variable resolves to something like "%SystemRoot%\system32\cmd.exe" the \K is an argument passed to it telling it to remain open after running the command that follows.

https://ss64.com/nt/cmd.html

Try:

INVOKE HIDE WAIT "[lcl]net use lpt1: \\192.168.xxxx\printershare"

this should run it in a minimized window.

https://manual.pvxplus.com/?directives/invoke.htm

I think the command you want is

/usr/pxpsqlodbc/pxpsql -d /facts/facts93 LIST AR_CUST_MAST

After LIST you just specify the table name not the word table and then the table name.

Performance will vary greatly based on OS, data, how the data is accessed etc. It is impossible to know what your performance difference will be.

I would suggest creating a copy of some data and encrypting it and running some tests if you want to know what the difference will be.