RE: Identity column restarting at 1 after recompile

I've hit this myself at a prior job.

Basically an issue between the way i5/OS and Aldon interact. The identity column current value is
stored in the table object. When you create a new version, the value gets reset to zero. But the
value doesn't get updated when the records are copied back, unless it's a "generate always" but in
that case, you get new identity values.

I ended up creating a RESETTBLID command that I could run as part of a post install.

If you'll on a later version (7.4+) of Aldon, check to see you have the "Try available update for
object replace" option turned on at the Global, Application, and/or release level.

That may help...as Aldon will try to use the Alter Table command instead of creating a new object and
copying the data.

Charles Wilt
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Wagner, Linda
Sent: Tuesday, February 26, 2008 9:18 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Identity column restarting at 1 after recompile

We just had to add a new column to a sql table and after the file was
recompiled we noticed that when new rows are inserted, the identity column
is reseeded with a starting value of 1. We assumed it would work like it
does in Sql Server and not reseed unless we told it to. I can't find
anything in the IBM documentation that refers to this. I know that we
could
add a "start with" value on the create table statement and hardcode the
next
value any time we have to modify the table, but there seems like there
should be a better way. If it makes any difference, we use Aldon as our
change management and normally just add the new column to the table and
promote it.



Thanks for any help.



Linda Wagner

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.