Re: AW: change column name in sql?

[Gqcy <gmufasa01@xxxxxxxxx>]

I sure hope nobody would refer to a column by index instead of by 
name!!!  :)




On 5/15/2013 7:55 AM, Vern Hamberg wrote:
> To add to this - I believe that we can add columns BEFORE another column
> - I just saw the BEFORE keyword - has to be a more recent release, of
> course.
>
> That makes this technique more flexible, I think - nice feature.
>
> HTH
> Vern
>
> On 5/15/2013 12:26 AM, Birgitta Hauser wrote:
> > There is no way to alter a column name, neither the long SQL nor the
> > short
> > system name.
> > What you can do is to add a new column with the desired name, data
> > type and
> > length. (If there are already data within the old column copy these data
> > into the new column).
> > And delete the old column after.
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training
> > them
> > and keeping them!"
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: rpg400-l-bounces@xxxxxxxxxxxx
> > [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
> > Auftrag von dale janus
> > Gesendet: Tuesday, 14.5 2013 22:58
> > An: rpg400-l@xxxxxxxxxxxx
> > Betreff: change column name in sql?
> >
> > We are creating some new files, err, tables using DDL. We created them
> > using ops nav.
> >
> > Before we start using them, I would like to change one of the long names
> > into something a little more accurate. But there appears to be no command
> > to alter table, alter column that applies to the column name.
> >
> > I can see where this is something that should only be done under special
> > circumstances.
> >
> > Since this is a new table, I can use ops nav to created sql source
> > statements, delete the table, change the name in the source, and then
> > execute the source.
> >
> > Is this the preferred method or is there a better way?
> >
> > ---Dale
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> > mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> > unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> > http://archive.midrange.com/rpg400-l.