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?

Devon,
One more question.  I am running the command line client on the same system as the database so I do not have the sql server running and it seems to work just fine *except* is appears not to see the non-normalized file.  Is that possible to enable, and even better, is there some documentation on the command line client that I somehow missed.

Thanks!
Michael

Devon,

here, with all variations on the "= 01" part:

 /usr/pxpsqlodbc/pxpsql -d /infor/facts78 select company,library from SM_UNFORM_LIBRARY_PATHS where company = "01"

This works just fine without the where clause.

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

I have a listview report style control for which I am trying to enable the lv'clickonhdrsort propery.  I set that property to 1, and it reports back as one, but I do not get sorting.  I'm sure there is another property that I need to adjust, but for the life of me I cannot figure out what it might be. I am seeing this at different PxPlus releases.

Has anyone figured out a clever way to bypass the limit on writing serial files larger than the 2 gig limit.  I can do it with a shell script on *nix, but I don't really want to pursue that.  I'd like something that is O/S agnostic and will work in *nix and windows.

This is a bit of a longshot, but in my experience working with excel, it is frequently looking for quote text.  So, the first thing I would try would be let TABLE=TABLE_CACHE'CREATEPIVOTTABLE("""Chart!A1""").   Good luck.