topic Re: Create Table statement in QlikView in QlikView

Create Table statement in QlikView

Thu, 26 Jun 2014 19:24:13 GMT

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

Re: Create Table statement in QlikView

Greg_Williams — Thu, 26 Jun 2014 19:29:23 GMT

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?

Re: Create Table statement in QlikView

Thu, 26 Jun 2014 19:33:02 GMT

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.

Re: Create Table statement in QlikView

vgutkovsky — Thu, 26 Jun 2014 19:36:41 GMT

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

Re: Create Table statement in QlikView

Thu, 26 Jun 2014 19:41:43 GMT

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

Re: Create Table statement in QlikView

Clever_Anjos — Thu, 26 Jun 2014 19:45:16 GMT

Try this

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

Re: Create Table statement in QlikView

Thu, 26 Jun 2014 19:50:11 GMT

This worked except I had to remove the EXEC statement.

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

Re: Create Table statement in QlikView

vgutkovsky — Thu, 26 Jun 2014 19:52:30 GMT

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