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

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

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