Re: Temporal tables: How to tell

To be honest, what functionality would an extension to DSPFD add that you
cannot get by reading the syshistorytables view?

Regards,
-Arco

Op donderdag 6 april 2017 heeft Rob Berendt <rob@xxxxxxxxx> het volgende
geschreven:

me and another guy are nudging each other to see who wants to create the
RFE...


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Arco Simonse <arco400@xxxxxxxxx <javascript:;>>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx
<javascript:;>>
Date: 04/06/2017 03:28 PM
Subject: Re: Temporal tables: How to tell
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx
<javascript:;>>



Hi Rob,

A DMPOBJ for a temporal and also the history table shows a *TEMPORAL_AREA*
for both.
So there is information in the file object. Seems that info has not made
it
to DSPFD yet...

Best regards,
-Arco

2017-04-06 19:46 GMT+02:00 Rob Berendt <rob@xxxxxxxxx <javascript:;>>:

If you make a table a temporal table, and make another table it's
versioning table, how do you know that a particular table is which? I've
searched through DSPFD to find a flag that says
"I'm a temporal table and this other table is my versioning table"
or
"I'm a versioning table for this other table"

I see SYSHISTORYTABLES at
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/
db2/rbafzcatsyshistorytbl.htm

Great table and all, but I know there has to be some way to rebuild that
(as in RCLSTG *DBXREF) or restoring those objects on to a new system.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx <javascript:;>
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx <javascript:;>
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx <javascript:;> for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx <javascript:;>
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx <javascript:;>
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx <javascript:;> for any subscription
related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx <javascript:;>
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx <javascript:;>
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx <javascript:;> for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD