On pxplus 15.10 debian version the below select statement does not return values from the record.
Pxplus 15.10 redhat version works properly.

What gives?

0010 open (hfn)"data/SO/SORSOH"; sorsoh=lfo
0020 select a0$,a5$,*,c5$,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,a4$ from sorsoh begin %a0$ end %a0$+%lc$
0030 print "Select returned '"+a0$+a5$+c5$+a4$+"'"
0040 print len(a0$+a5$+c5$+a4$)
0050 break
0060 next record
0100 read (sorsoh,key=%a0$,dom=*next)
0110 read (sorsoh,end=EOF)a0$,a5$,*,c5$,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,a4$
0120 print "Read returned '"+a0$+a5$+c5$+a4$+"'"
0130 print len(a0$+a5$+c5$+a4$)
0140 EOF:stop
-;
-;run
Select returned ''
 0
Read returned '01033482IDBNN           NNNN          '
 38
-;

I'm using the 'TJ' parameter to troubleshoot an intermittent issue and found that a setting of over 10000 causes an error 41.

1}set_param 'tj'=10000
1}set_param 'tj'=10001
Error #41: Invalid integer encountered (range error or non-integer)
1}

Will you please update the manual to show this limit?

How can I programmatically tell if a program is passworded?
I have a process that copies all programs and I need to skip the passworded ones since *ufc errors on them.
fin() and fib() don't seem to hold that info.

TIA

Is it possible to create a .xlsx file (not .csv) in a Linux environment only. There is no access to Windows or Excel or even a machine running those. First choice would be to use only pxplus, next best would be to look for some java that might have that capability.

Just wondering if anyone else has tackled this challenge.

For VLR files I have a note of the following file size limitations.
BSZ values and files sizes for VLR files
0=2GB, 4=8GB, 8=65GB, 12=98GB
Yet we have a VLR file where BSZ=4 and it is 28GB.
Are my notes wrong?
This is what I'm seeing:
-}end
-}delete
-}?prm('MB')
  0
-}?fin("/facts93/data/GL/GLYJNL","FILE_CREATE")
KEYED "/facts93/data/GL/GLYJNL",[1:1:2]+[2:1:4]+[3:1:4]+[4:1:4]+[5:1:5],[1:1:2]+[2:1:4]+[6:1:10]+[3:1:4]+[4:1:4]+[5:1:5],[1:1:2]+[2:1:4
]+[3:1:4]+[4:1:4]+[9:1:5],[1:1:2]+[2:1:4]+[3:1:4]+[8:1:45]+[4:1:4]+[5:1:5],[1:1:2]+[6:1:10]+[2:1:4]+[3:1:4]+[4:1:4]+[5:1:5],[1:1:2]+[2:
1:4]+[3:1:4]+[6:1:10]+[4:1:4]+[5:1:5],[1:1:2]+[2:1:4]+[3:1:4]+[4:1:4]+[6:1:10]+[5:1:5],[1:1:2]+[10:1:3]+[11:1:6:"D"]+[2:1:4]+[3:1:4]+[4
:1:4]+[5:1:5],0,-768,BSZ=4,OPT="0"
-}

> pwd
> /facts93/data/GL
> ls -l -h GLYJNL
-rw-r--r--. 1 facts facts 28G Dec 14 14:42 GLYJNL

So what gives??? 

BTW: The online documentation still shows the max file size for Pvx data files as 2GB with a note about the 'MB' param. I believe that limitation was removed some versions back.

Are there plans to update PxBasic? I notice the download is about 10 years old. Does it even run on Windows 11?
This would be for personal, non-commercial use.