[ https://issues.jboss.org/browse/TEIID-2584?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2584: ------------------------------------- Will this work? {code} create procedure refreshMatView(viewName, criteria) AS BEGIN mv = getMV($viewName) delete from $mv where $criteria; select * into $mv from (loadscript) AS X where $criteria END {code} for above, I will have the proper transitions of status in the "matview status" table. Since I was using select transformation when load script is not provided, this information is needed now. Will move Transformations to Triggers, and move from extension properties to proper column names like {code} create table Triggers ( schema string; table string; type string; -- valid values (SELECT, INSERT, UPDATE, DELETE, INSTEAD OF INSERT, INSTEAD OF UPDATE, INSTEAD OF DELETE) sql_stmt string; ); {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira