Re: reordering SQL defined table

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