Support for explicit period specification on views
Db2 11 extends temporal support by enabling you to specify period specifications and period clauses for views. This enhancement makes implementing temporal tables easier and improves SQL consistency across the Db2 family of products.
Now, you can specify a period specification following the name of a view in the FROM clause of a query. When you query a view that references a system-period temporal table, an application-period temporal table, or a bitemporal table, you can specify a point in time or time range for a system period (SYSTEM_TIME) or an application period (BUSINESS_TIME). With this enhancement, you experience the same behavior whether you are querying a base table or a view.
Also, you can specify a period clause following the name of a target view in an UPDATE or DELETE statement. For example, you can specify a period of time for a BUSINESS_TIME period for an update or delete operation on a view that references an application-period temporal table or a bitemporal table. As a result, you experience the same behavior for the data change operation whether the operation is on a base table or a view.
Additional enhancements help to minimize the invalidation of packages for temporal tables, even if you alter a table that is referenced in a view definition and a statement that references the view is bound in a package.