How to Use Temporal Tables on DB2 for IBM i
In this short How To …. On IBM i Video set, I will walk you through my user group presentation on DB2 for i.
This presentation was first given to the iUG in the UK in 2023.
Don’t forget like & subscribe & if you like my creative work, buy me a coffee! https://ko-fi.com/andyyouens
⌚ Timestamps
— Contents —
00:00 – Intro
00:41 – What are temporal tables
06:27 – Creating temporal tables
07:59 – History tables
08:54 – Creating the history table
09:54 – Linking temporal & history tables
10:05 – Using ACS for temporal
10:48 – Make existing tables temporal
12:32 – Inserting data into temporal tables
13:24 – Updating data into a temporal table
13:44- Deleting data in a temporal table
14:11 – Querying temporal data
15:08 – Using the AS OF
15:39 – Using FROM & TO
16:12 – Using BETWEEN
16:42 – Do you have any temporal tables on your server?
17:13 – Stop versioning
18:03 – Use partitioning for your large history files
19:30 – GitHub examples & slides
19:45 – Check out learning.formaserve.co.uk & Powerwire.eu
20:08 – Wrap Up!
🚩 Connect with us on social
– LinkedIn: https://linkedin.com/in/andyyouens
– LinkedIn: https://www.linkedin.com/company/formaserve-systems/
– Twitter: https://twitter.com/AndyYouens
– Twitter: https://twitter.com/FormaServe
– Website: https://learning.formaserve.co.uk
– Website: https://www.formaserve.co.uk
🔔 Subscribe to my YouTube channel https://www.youtube.com/FormaServeSystemsLtdLoughton?sub_confirmation=1
👋 Additional resources
– GitHub: https://www.github.com/FormaServe/f_learning
📃Playlists
– BASH on IBM i: https://www.youtube.com/playlist?list=PLohFZaDbDd2Pn7e4xMCsl5TQakkVUow8U
– Open Source on IBM i: https://www.youtube.com/playlist?list=PLohFZaDbDd2Pj6A6Uaz_pfKGP6zmJohJ2
– Programming on IBM i: https://www.youtube.com/playlist?list=PLohFZaDbDd2Pg-OiESOSk8JBSkeaFjLA7
– IBM DB2 for i: https://www.youtube.com/playlist?list=PLohFZaDbDd2NUtmAhBBn-TdKNMXkwu9ha
– Marketing: https://www.youtube.com/playlist?list=PLohFZaDbDd2Onve_ZFIgglJrxP8Rl33cn
-☕ Could really do with a coffee after producing this video – https://ko-fi.com/andyyouens
Comments are closed.