RE: SQL CREATE TABLE command - ALIAS

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

Thanks, Birgitta!

It turns out this is not compatible with any other database, though.  Is
there a way to set those names later?  Maybe create the table with the
long name, then later ALTER the column to have a short and long name?

I can work around it, but I am trying to write machine-independent
routines and it's pretty difficult.

Joe

> From: Hauser, Birgitta
> 
> Hi Joe,
> 
> you can specify the short field name in the create table statement as
> follows:
> 
> Create Table MySchema.Dummy
>        (Description for ShortDescr VarChar(50))
> 
> In RPG you can use the field ShortDescr in SQL you can use both
> Description or ShortDescr.