Re: Question on Long Column Names Returned from SQL Query. I Want Short Column Names

[Charles Wilt <charles.wilt@xxxxxxxxx>]

What version of ACS?

I know I've switched from long to short names in the past, but that doesn't
seem to be an option in the latest version (Version: 1.1.8.8)...

Or maybe I'm losing my mind.

Charles



On Wed, Nov 3, 2021 at 1:28 PM Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
wrote:

> 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
> DEFAULT 0,
>         PRIMARY KEY( WORK_ORDER_NUMBER ) )
>         RCDFMT DWSERVICE ;
>
> Tests:
> 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.
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net
> Email: richard@xxxxxxxxxxxxxxxxx
> --
> 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,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com