Create Table statement in QlikView

[#1]

Is it possible to execute a create table or replace view statement over ODBC in qlikview?

[Greg_Williams]

QlikView can execute a stored procedure to build a table. One can also use inline tables to build content. Is this what you are referring to?

[#3]

Not exactly.  I literally need to execute a REPLACE VIEW in our database from QlikView.  I don't want to go the stored procedure route as this will limit my ability to scale this.  We use Teradata and I realize I could write a BTEQ script but again that creates more moving parts.  I was hoping there was a way to send the SQL directly back through QlikView however it appears that out of the box it can only parse a select statement.

[vgutkovsky]

Well, I haven't tried this myself, but I gather that this is possible by selecting the "Open Databases in Read and Write mode" checkbox in the script editor:

Regards,

Vlad

[#5]

I tried that but Im getting an error "Unknown Statement".

Using syntax

REPLACE VIEW schema.ViewName

AS LOCKING FOR ROW ACCESS

Select * from schema.tablename

[Clever_Anjos · Accepted solution]

Try this

SQL EXEC REPLACE VIEW schema.ViewName AS LOCKING FOR ROW ACCESS

[#7]

This worked except I had to remove the EXEC statement.

I guess it just needed to know that I was indeed passing SQL

[vgutkovsky]

As long as you also check the Read and Write checkbox, right...?