RE: Identity column restarting at 1 after recompile -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Thanks, Charles, for the info and explanation. I'll try changing that
option and seeing if that takes care of the problem.

-----Original Message-----
date: Tue, 26 Feb 2008 10:01:06 -0500
from: "Wilt, Charles" <WiltC@xxxxxxxxxx>
subject: 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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.