RE: Problem with GENERATED ALWAYS Identity column

Paul,

Yes, that's what I did also.  It works but it shouldn't have been needed to be 
done.

Did you open a PMR with IBM?

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 Paul Morgan
> Sent: Wednesday, August 03, 2005 3:52 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Problem with GENERATED ALWAYS Identity column
> 
> 
> Yeah, that's not the table.  My mistake.  I thought there 
> would be some SQL
> system table with the value but maybe not.
> 
> We had this problem here and just used the file values to 
> reset the index
> above any existing record.
> 
> Paul
> 
> -- 
> Paul Morgan
> Senior Programmer Analyst - Retail
> J. Jill Group
> 100 Birch Pond Drive, PO Box 2009
> Tilton, NH 03276-2009
> Phone: (603) 266-2117
> Fax:   (603) 266-2333
>