Hi Paul, 2nd attempt after using other email :(
Might be an idea to set the *CURRENT record to high values to enable
sequencing by descending key value.
Thanks and best regards,
David A. Wood
PMP
IBM i Specialist see Merlin
david@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Tel: Aus +61 (0)424 604513 or 03 9742 2247
Skype: davidandrewwood7
(Melbourne, Australia)
-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Holm, Paul
Sent: Friday, 16 January 2015 12:52 PM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Row / Record Versioning Design
Hi,
Looking for design ideas or experience with the following.
We are creating a DB to hold equipment where each record holds a description
of equipment. They want to have the ability to have 1 to many "versions" of
the record. For example, if a device firmware or configuration is updated,
they want to maintain the old record.
I'm thinking I can accomplish all this by simply adding a "Version" column
to the database. Version could have values such as "1.0", "1.2", or
*CURRENT if it's the latest. When a new version is needed, we simply copy
the record and update the VERSION field.
Feedback with this approach?
Thanks in advance, Paul
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
midrange.com
