Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
User Maintained Materialized table
Hmmm, I'll look into that. It could work. Thank you. -
User Maintained Materialized table
Hi, I could use SQL to update and fill the table. But the 2 base tables are updated by an import every 15 minutes and completely refreshed by a Load each day. If I don't use the "refresh table"-command I will have to truncate the materialized table and insert it with a query every 15 minutes... -
User Maintained Materialized table
Hello juliane6, thank you for your reply but I need a "maintained by user" because I will have to update the materialized table directly in certain cases. Sorry, I was not clear on this point. So I need to use the "refresh table"-statement to fill the table with data from the underlying... -
User Maintained Materialized table
Hello, I was wondering if anybody could help me with defining a refreshable, user-maintained materialized table. The documentation states that it is possible to update an user-defined materilized table "by using the LOAD utility, the INSERT, UPDATE, and DELETE statements, as well as the...
