This is configured for 64 bit on RH 7.9. unixODBC is installed. If I do this:
[root@rhlinux etc]# /usr/pxpsqlodbc/pxpsql -d /facts93 LIST |grep AR_CUST
AR_CUST_BY_ALPHA
AR_CUST_BY_CLASS
AR_CUST_BY_CNTCT
AR_CUST_BY_DOC
AR_CUST_BY_PHONE
AR_CUST_BY_SLSP
AR_CUST_BY_ZIP
AR_CUST_CLASSES
AR_CUST_CLASSES_AKT
AR_CUST_CROSS_REF
AR_CUST_LDGCARDS
AR_CUST_MAST
AR_CUST_PRC_CLS
AR_CUSTOMER_HISTORY
AR_CUSTOMER_NOTES_A
AR_CUSTOMER_NOTES_B
AR_CUSTOMER_NOTES_C
You can see AR_CUST_MAST as a table. Good. Now this:
[root@rhlinux etc]# /usr/pxpsqlodbc/pxpsql -d /facts/facts93 LIST table AR_CUST_MAST
ERROR: Invalid Table Name or No Columns Returned By LIST Columns Command.
Since (think) I know the table name is good, what would cause the column list to fail. Providex.ddf shows the file, and the file has an embedded IO list (as well as an IO program, see attached.
Any insight appreciated. - Michael