How can I use DDL in DBX3?

[jsyoon]

Hello, in Splunk 6.5.x and dbx1 DDL was available.
I could create, insert, update, delete data in the table.

But now I'm using Splunk 7.1.x and dbx3.
How can I use DDL with this environment.

Thanks,

[tmuth_splunk]

DDL is not formally supported in DBX 2.x or 3.x. Depending on the database (Oracle, SQL Server, ...) you can encapsulate your DDL in a stored procedure and call that stored procedure from dbxquery