I have pxpsql configured on a ReHat box and can query a table just fine with

/usr/pxpsqlodbc/pxpqsql -d /infor/facts78 "select Customer_num form AR_CUST_MAST where AR_CUST_MAST.company = '01'"

and the whole table dumps. On the other hand, in both my PxPlus environment, and the one from SDSI this only returns 10 rows before generating an error 2:

open(hfn)"[odb]FACTS;AR_CUST_MAST"
READ(LFO)*,CUST$;PRINT CUST$;GOTO *SAME

Any insight here is appreciated.

Michael

I am having to set up a table that can be accessed from sql server. The schema I have been given to replicate has the primary key as an auto-increment bigint.  I figure I can use the "I" option in a keydef and wind up with an adequate key as bigint is signed and the GUID type data involved is not, so 4 bytes would get me what I need.  I can define a file such as 'keyed "test",[0:1:4:"I"),0,-1000' with no problem.  My issue is how one write to is such that the key autoincrements.  Michael

I am attempting to cause a log file to not buffer.  From what I can tell from the docs is that -B should be used in an open, like open(hfn,opt="-B")mylog.txt.

This does not seem to be working.  Am I misinterpreting the documentation?

I have attempted installing both the 7.00 and 6.10 version of the above on a Redhat 7 system.
 cat os-release
NAME="Red Hat Enterprise Linux Server"
VERSION="7.8 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.8"
PRETTY_NAME="Red Hat Enterprise Linux"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:7.8:GA:server"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.8
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.8"

From the command line I can do a list command and a select command with no problem, but as soon as I add a where clause I see this:

The driver reported the following diagnostics whilst running ODBCExecDirect
S0000:1:1019:[PxPlus][SQL ODBC Driver]Internal error

I added -l odbc.log and it has this:

Driver version: 7.00.0000
ISAMOpen: UserID='root', length=4
------------------------------
select company,library from SM_UNFORM_LIBRARY_PATHS where company = 01

GetAccessibleTables:<table=SM_UNFORM_LIBRARY_PATHS> Open catalog(s) /infor/facts78 , available 710 table(s)
<SM_UNFORM_LIBRARY_PATHS> Open file /infor/facts78/data/SM/SMUNFP, maxksz=20
ISAMCloseTable: Closing table SM_UNFORM_LIBRARY_PATHS - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 2048 estimated, 0 used
ISAMClose

This is so close to working as I need it, but obviously this last needs to work.

Any input?
Michael

Customer is running ODBC 5.20.0002.  Recently upgraded to Office 2016. Queries ran with earlier versions of excel that contained an "ORDER BY" clause.  Now the are failing and reporting "[PxPlus][ODBC Driver][FILEIO]No data found.  When the order by is removed the query executes.  Has anyone dealt with this?

Running PxPlus file server ver:5.20.0002 on linux I am getting the above error on one SQL query.  Any insight as to what this might be telling me?

On PxPlus 12.51 I see this:
2260 print (10)@(30),fnif(sorsop.type$="D",num(sorsop.orig_amt$),-num(sorsop.amount$)):y3$+" "+tbl(pos(sorsop.type$="DEORAT")-1,"",sorsop.reason$+" "+forfeit_reason$,"",sorsop.memo$,"",sorsop.note$); l=l+1; goto NEXT_DEP_TRANS

The contents of sorsop.memo$+sorsop.notes$ is ABCABCABCABCABCABC BLUE BUBBLES.  All of the B's are dropped, whether printing to a device (notepad) or to the console.  Note what should probably throw an error is that the first output is a masked numeric field passed through y3$ which is concatenated to a string value.  Simply changing that "+" to a comma rectifies the issue.  Attached doc shows this.