RE: Problem with GENERATED ALWAYS Identity column

Thank you,


I was rather proud of that one.....


I wonder if the IBM's reading my PMR will get the message...



Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Walden 
> H. Leverich
> Sent: Thursday, August 04, 2005 2:41 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Problem with GENERATED ALWAYS Identity column
> 
> 
> >permanent restriction - IBM's way of saying that they rushed a new
> 
> >feature into the OS without consideration to current features or the
> 
> >fact that the i is supposed to stand for "integrated".
> 
> Priceless!
> 
> And it would seem to me that the fix would be trivial. Fix 
> CPYF to look
> at the next # for the copy from file and then internally 
> issue a "ALTER
> TABLE TOLIB.TOFILE ALTER COLUMN ID1 RESTART WITH n" command where n is
> the number you got in the copy from file.
> 
> -Walden
>