AW: AW: change column name in sql?

Column ORDINAL_POSITION within the SYSCOLUMNS view

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 Tom E Stieger
Gesendet: Wednesday, 15.5 2013 17:01
An: RPG programming on the IBM i (AS/400 and iSeries)
Betreff: RE: AW: change column name in sql?

Where is the ordering of columns stored? I just looked at qsys2.syscolumns
and didn't see any sequencing or ordering of the column names. Not that I
would ever want to look for the 4th coumn of a table specifically, but I
have noticed that different interfaces can display the column names in
different orders.


-Tom Stieger
IT Manager
California Fine Wire



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gqcy
Sent: Wednesday, May 15, 2013 7:42 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: AW: change column name in sql?

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.

--
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.

--
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.