[ https://issues.jboss.org/browse/TEIID-2584?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2584: ------------------------------------- Two questions on this (the reason why I went current route) 1) Currently both SYS and SYSADMIN are both categorized as "SOURCE" schemas, should I add another at "VIRTUAL" schema for this purpose? 2) How can I look up metadata inside the virtual procedure? To execute as system procedure in SYSADMIN, I could not fold all the needed statements like truncate/load/swap into single statement. I will rewrite using "merge". Also, since these are async loads I was not concerned about the performance hit. -- 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