Re: Short column name in CREATE TABLE AS ?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

create table NEW_TABLE (col_abc,  COUNTER_VALUE for CNTRVAL)
  as (
         select COL_ABC,
         cast(0 as decimal(3))
    from EXISTING_TABLE
) with no data ;

HTH,
Charles

On Thu, Apr 16, 2026 at 11:42 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx>
wrote:

> Given this sample SQL, how can I set the short, system column name for the
> new column  COUNTER_VALUE ?
>
> create table NEW_TABLE as (
>   select COL_ABC,
>     cast(0 as decimal(3)) as COUNTER_VALUE
>     from EXISTING_TABLE
> ) with no data ;
>
>
> Thanks
> --
> 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.