-
1. Re: Execute DDL, DML, DCL and TCL Sqls statement on Teiid connection.
shawkins May 31, 2016 9:05 AM (in response to praksah)See SQL Support · Teiid Documentation for all of the DML, DDL, and TCL that are executable at runtime. There is also more DDL that can be used do define a vdb - DDL Metadata · Teiid Documentation
DCL is just currently defined in xml - Data Roles · Teiid Documentation
-
2. Re: Execute DDL, DML, DCL and TCL Sqls statement on Teiid connection.
praksah May 31, 2016 10:16 AM (in response to shawkins)I mean to say, Does these statement executed on physical database. eg. If I execute create table statement then is it create on physical database?
-
3. Re: Execute DDL, DML, DCL and TCL Sqls statement on Teiid connection.
praksah May 31, 2016 10:17 AM (in response to praksah)As per the documentation, We can execute DDL on virtual(temporary) database
-
4. Re: Execute DDL, DML, DCL and TCL Sqls statement on Teiid connection.
shawkins May 31, 2016 10:25 AM (in response to praksah)Yes, DDL/DCL is effectively for the VDB. DML will be pushed as needed, and TCL will cause XA and local transaction sources to participate in the Teiid cooridnated transaction.
-
5. Re: Execute DDL, DML, DCL and TCL Sqls statement on Teiid connection.
rareddy May 31, 2016 10:35 AM (in response to praksah)Teiid does not fully support DDL at runtime, it only supports in creation of Temporary tables, couple other ALTER statements. There is much more of DDL support at design time, which goes directly into the -vdb.xml file, that is link SteveH gave above. DCL is defined in Teiid's own terminology in the -vdb.xml file see [1]