[ https://issues.jboss.org/browse/TEIID-2584?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2584: --------------------------------------- You could use a single system procedure with dynamic sql by passing in just the fully qualified name (probably in parts) and then use system lookups for the metadata. Generally though there may be a performance hit from the atomic blocks as we'll be using an XA transaction rather than a local transaction, but there's not much we can currently do about that as the language/high-level processing does not know about connection management. I see at first you are selecting to test validatity with a transaction around the insert. Is there a primary key or other constraint that would prevent two inserts? Otherwise the txn block won't matter - but you may need to add exception handling to catch the pk violation. Ideally you could use a merge statement in the place of the select/insert/update, but ours is currently too simplistic. -- 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