Re: reordering SQL defined table

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

By the way, the "BEFORE" in  "... ADD COLUMN column-definition BEFORE
column-name" is only available in 7.1 and later.


 Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 795-2111 ext. 3098
Cell: (416) 317-3144

On 3 October 2014 14:31, Scott Mildenberger <
SMildenberger@xxxxxxxxxxxxxxxxxx> wrote:

> Not sure in Navigator but ALTER TABLE can, excerpt from the manual.
>
> ALTER TABLE table-name
>
> COLUMN ADD column-definition BEFORE column-name
>
> I would assume that Navigator could do this also.
>
> Scott
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Mike Cunningham
> Sent: Friday, October 03, 2014 12:26 PM
> To: Midrange Systems Technical Discussion
> Subject: reordering SQL defined table
>
> Is there a way using System i Navigator when defining columns for an SQL
> table, to reorder the existing columns? Like if the table has 50 columns
> and you are adding a new column but don't want it on the end, is there a
> way to add it as the 10th column on the table?  In DDS days that was done
> by moving he lines of DDS source code around and doing a CHGPF
>
>
> Mike Cunningham
> Vice President of Information Technology Services/CIO Pennsylvania College
> of Technology