Avatar of Srikanth Vishnuvajhala
Srikanth Vishnuvajhala

asked on 

Creating Materialized View in DB2

I want to create a Materialized View in IBM-DB2, which is called Materialized Query Table. I have a table "xyz" and it has say "n" columns and one of them is "id". I am given list of ids as input. I need to extract records for those input list of ids from "xyz" table using the materialized view every 15 min.

Can you please help me how to solve this. Thank you.
DB2* Views

Avatar of undefined
Last Comment
Tomas Helgi Johannsson

8/22/2022 - Mon