Re: Journal entry for identity column changes?

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

We moved to a new machine in February we think it got screwed up then.

I reviewed most all of our other tables and they all look ok.

On Fri, Jul 9, 2021 at 5:24 PM Tyler, Matt <matt.tyler@xxxxxxxxxxxxxx>
wrote:

> And I forgot to mention that CPYF also overrides the current identity key
> value.  When we update tables our CMS replaces the table completely, which
> means it's a new object with a beginning identity key value.  The new table
> is populated from a back up of the prior version but the identity key value
> is still the same beginning value.  The CMS product has an exit point that
> runs a program that we wrote to get the largest value, add one then update
> the table with an "ALTER TABLE table ALTER COLUMN column RESTART WITH ###"
> statement.
>
> -Matt
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Tyler, Matt
> Sent: Friday, July 9, 2021 3:15 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: RE: Journal entry for identity column changes?
>
> Did you know you can override the identity value when you insert rows?
>  Read up on OVERRIDING SYSTEM VALUE and OVERRIDING USER VALUE.   If the
> table's identity value was lower than any inserted records (with one of the
> attributes specified when inserted), the next insert without those
> attributes would cause a dup key error, assuming you put a unique clause or
> PK over the ID column.
>
> -Matt
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
> Tostaine, Jr.
> Sent: Thursday, July 8, 2021 7:49 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Journal entry for identity column changes?
>
> We had a table start getting duplicate keys this morning. I reset the
> identity column value to a higher number and all was well.
>
> Shouldn't I see a journal entry for that table that shows the value was
> changed?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit:
> https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!ozGMtQREkGN9cImg2BErGDhzOaq_f87B0GTSUXLL1tyJ7iJxA8-uo24ayljynKigKGfG$
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!ozGMtQREkGN9cImg2BErGDhzOaq_f87B0GTSUXLL1tyJ7iJxA8-uo24ayljynBBRf5Q_$
> .
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Yk!ozGMtQREkGN9cImg2BErGDhzOaq_f87B0GTSUXLL1tyJ7iJxA8-uo24ayljynJA3fCz5$
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit:
> https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!oaKxc5RqArX4UDIHZioPt4Eao5FFLnhj0171UTI2w1phUdn6PEKn-nwyWYw9QAiHz7lU$
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!oaKxc5RqArX4UDIHZioPt4Eao5FFLnhj0171UTI2w1phUdn6PEKn-nwyWYw9QOTS45Ep$
> .
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Yk!oaKxc5RqArX4UDIHZioPt4Eao5FFLnhj0171UTI2w1phUdn6PEKn-nwyWYw9QJIBZcxl$
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com