Here's an example if anyone else wants to try this. I'm on V7R3 and maybe
not at latest PTF level as well :
CREATE TABLE QGPL/DWTEST (
WORK_ORDER_NUMBER FOR COLUMN FTWON NUMERIC(9, 2) NOT NULL
PRIMARY KEY( WORK_ORDER_NUMBER ) )
RCDFMT DWSERVICE ;
If you do SELECT * FROM QGPL/DWTEST, do you see: WORK_ORDER_NUMBER as the
heading ? ( I do)
If you do SELECT WORK_ORDER_NUMBER FROM QGPL/DWTEST, do you see:
WORK_ORDER_NUMBER as the heading ? ( I do)
If you do SELECT FTWON FROM QGPL/DWTEST, do you see: WORK_ORDER_NUMBER as
the heading ? ( I do. It should show FTWON, but doesn't)
I get the same results in ODBC, STRSQL or ACS SQL.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.