Thanks for sharing Charles, <snip> to </snip> is going in my recipe book!
I especially enjoyed and empathized with the humorous sarcasm. . . applied
in slight doses. . . later in the thread.
Of course if your HA vendor is Mimix or Help Systems they won't have
support for Temporal Tables for a year or so but they sure do appreciate
your paying maintenance.
Heh heh heh,
John
<snip>
The right way to do this..
1) Create a SQL table with all the same columns + a GENERATED ALWAYS AS
IDENTITY column
2) Copy the data from the existing PF to the new table.
3) Recreate the existing logicals, pointing them to the new table with an
explicit field list that leaves off the new identity column.
4) Delete the old physical, create a new logical with the original
physical's name. Again, with an explicit field list that leaves off the
new identity column.
Done correctly, you don't have to recompile any programs.
You can tell it's done correctly by checking the record format ID for all
the logicals + original physical...
Record Format List
Record Format Level
Format Fields Length Identifier
MYFORMAT 31 416 5530F7BBE8D09
As long as the format record identifier is the same before & after, you
won't get level checks.
Charles
</snip>
<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.
midrange.com
