CODEWITHSUNDEEP
sqldb2
sama
sama

Reputation: 341

Does DB2 Support temporal tables join and aggregation?

I am looking for a resource which indicates whether Db2 on Ubuntu supports temporal tables join and aggregation or not.

Example:

customer (
  customer_id ,
  name ,
  address ,
  valid_period ,
  tx_period 
);

orders (
  order_id ,
  customer_id,
  order_total,
  valid_period ,
  tx_period 
);

Does DB2 support temporal join for these kind of tables on period fields?

Upvotes: 0

Views: 115

Answers (1)

data_henrik
data_henrik

Reputation: 17118

The Db2 documentation has information on restrictions for system-period temporal tables. They also apply for bi-temporal tables. Next, look at querying bi-temporal tables. It is combining predicates on application periods and system periods.

Upvotes: 1

Related Questions