topic Re: Need clarification on qlikview drop table statement in QlikView

Need clarification on qlikview drop table statement

Tue, 10 Sep 2013 09:29:14 GMT

Hello,

I got a script like this.

Connect to database (Oracle)

TEST :

SQL

Select * from dual;

drop table TEST;

My question is how qlikview differentiates the drop table statement is a qlikview one but not a oracle statement .

Thanks in advance for all your replies

Re: Need clarification on qlikview drop table statement

swuehl — Tue, 10 Sep 2013 09:30:50 GMT

Good question 😉

The SQL statement string ends with the semi-colon ';'

Re: Need clarification on qlikview drop table statement

jonathandienst — Tue, 10 Sep 2013 09:33:23 GMT

Only the contents of the SQL statement get passed to the DB server (ie up to the ; ), so the drop table is executed by QV, not the DB.

Hope that helps

Jonathan

Re: Need clarification on qlikview drop table statement

Tue, 10 Sep 2013 09:43:03 GMT

But i tried like this and it gave me the explain plan. So does that mean qilkview ends the DB script immediately after first occuring SELECT statement ?

Connect to database (Oracle)

TEST :

SQL

explain plan for Select * from dual;

select * from table(dbms_xplan.display);

drop table TEST;

Re: Need clarification on qlikview drop table statement

jonathandienst — Tue, 10 Sep 2013 09:45:49 GMT

Up to the semicolon. You would need two SQL statements to send two queries.

Re: Need clarification on qlikview drop table statement

Tue, 10 Sep 2013 09:47:57 GMT

Hello Jonathan,

Thank you. But it gave me with single SQL statement .Thats were i got confused.

Re: Need clarification on qlikview drop table statement

swuehl — Tue, 10 Sep 2013 09:49:38 GMT

You can think of an implicite SQL before your SELECT (SQL in front of SELECT is optional, both versions are valid syntax). So you have two SQL statements, both ended with a semi-colon.

Re: Need clarification on qlikview drop table statement

Tue, 10 Sep 2013 09:53:02 GMT

Thank you swuehl. I never knew that. That answers my question.