Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to execute a create table or replace view statement over ODBC in qlikview?
Try this
SQL EXEC REPLACE VIEW schema.ViewName AS LOCKING FOR ROW ACCESS
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?
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.
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
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
Try this
SQL EXEC REPLACE VIEW schema.ViewName AS LOCKING FOR ROW ACCESS
This worked except I had to remove the EXEC statement.
I guess it just needed to know that I was indeed passing SQL
As long as you also check the Read and Write checkbox, right...?