RE: Change column name on DDL SQL table in iSeries Navigator

With great power, comes great responsibility.

-----Original Message-----
From: Jim Oberholtzer [mailto:midrangel@xxxxxxxxxxxxxxxxx]
Sent: Tuesday, May 21, 2013 9:59 AM
To: Midrange Systems Technical Discussion
Subject: Re: Change column name on DDL SQL table in iSeries Navigator

and creates much of the data integrity and corrupted data base issues that MS SQL is famous for....

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 5/21/2013 9:27 AM, Matt Olson wrote:

Yep contains data already. I'll put in a DCR to get this fixed, the way SQL Server handles this scenario is so much more elegant and saves a lot of time.

-----Original Message-----
From:rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Tuesday, May 21, 2013 9:24 AM
To: Midrange Systems Technical Discussion
Subject: Re: Change column name on DDL SQL table in iSeries Navigator

Does the table already contain data? If not, delete the column and re-add. iNav allows you to change the system name, but I bet you think that's like kissing your sister.

The reach around is to run something like this:
create table newtable as (select colA as newcolumn, colb, colc, cold,
cole... from oldtable) drop oldtable rename

<snip>
For the life of me I can't figure out why it doesn't allow column renames.
</snip>
Experience has shown me that most people really don't care to figure out why - they just want things to work the way they want them too. That mentality is not always a bad thing.
You can submit a Request for Design Change (aka DCR).

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Matt Olson<Matt.Olson@xxxxxxxx>
To:"midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>,
Date: 05/21/2013 10:08 AM
Subject: Change column name on DDL SQL table in iSeries Navigator
Sent by:midrange-l-bounces@xxxxxxxxxxxx



Anyone figure out how to rename a column in iSeries navigator on a SQL
DDL table?

For the life of me I can't figure out why it doesn't allow column renames.
--

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