[teiid-issues] [JBoss JIRA] (TEIID-5232) Add ability to call system functions on VDB Datasource

Add ability to call system functions on VDB Datasource ------------------------------------------------------ Key: TEIID-5232 URL: https://issues.jboss.org/browse/TEIID-5232 Project: Teiid Issue Type: Feature Request Reporter: Debbie Steigner Assignee: Steven Hawkins Add ability to call the system function teiid_session_set on a EAP VDB datasource When i send : select teiid_session_set('project','myProject'); My session variable is changed only on my vdb. I would want to send this command to my VDB EAP datasource. I need to let my vdb's client the opportunity to call teiid_session_set in one of my datasource dynamically. For now, the only way i have found is putting this on my datasource configuration : <new-connection-sql>select teiid_session_set('country','BELGIUM')</new-connection-sql> The problem is that this sql request is only called once, at the vdb deployment. I would like to be able to call this request at runtime.