Re: DDS versus SQL DDL question

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

rename table  CUSTOMER_MASTER
  to system name CUSTMASTR

Charles


On Sat, Oct 18, 2008 at 11:53 AM, Mark S. Waterbury
<mark.s.waterbury@xxxxxxx> wrote:
> Thanks to all who replied.
>
> If someone has created a table with column names longer than 10
> characters, and did not specify that short name, DB2 automatically
> generates a short name like "CUSTO00001" ... :-o
>
> I cannot see any way to change those short names, once they are
> generated, e.g. via ALTER TABLE.
>
> Does anyone know if this is possible, or do I just have to create a new
> table (with CREATE TABLE) and then copy the data over to it?
>
> Thanks.
>
> Mark S. Waterbury
>
>  > Charles Wilt wrote:
> > create table mytable (
> >   customer_number for CSTNBR numeric(5,0)
> > )
> >
> > HTH,
> > Charles
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.