This content has been marked as final.
Show 1 reply
-
1. Re: Executing DML on Teiid VDB
rareddy Mar 23, 2018 9:10 AM (in response to bibhuti.bhusan)1 of 1 people found this helpfulDML is about executing SELECT/UPDATE/INSERT/DELETE statements on a datasource, and yes you can issue these commands using the Teiid client (JDBC, ODBC, ODATA) to a VDB which in turn queries from the the Oracle database through the translator configured in VDB definition. I suggest getting yourself familiarized with basics and quick start example.
If are asking about DDL, no there is no direct way to execute any of create table, alter table kind of statements through Teiid to Oracle. Teiid expects the schema information to be present in the database before you begin. There is way to execute a SQL command directly using Direct Query Procedure for some scenarios but not full support.