SQL Scripting

[#1]

Hello Community members,

I have doubt regarding SQL scripting, can we develop total project using the sql commands and scripting in qlikview. If any one had developed the project, please post a sample sheet for me

[Gysbert_Wassenaar]

Qlikview itself doesn't understand sql. Qlikview simply passes any sql statement (anything starting with SQL or SELECT) to the dbms for execution and treats the returned results as a table. So you can put any sql statement in your script in your Qlikview document. As long as it's a valid sql statement for your dbms it should return results. Two examples:

// simply load everything from mytable into a table called Table1

Table1:

select * from mytable;

//first load a,b and c from myothertable, then load a and b+c as d into Table2

//this is called a preceding load and can be used to process the data (with qlikview functions) from the sql statement

Table2:

load a, b+c as d;

select a,b,c from myothertable;

[#3]

Thanks for your response Gysber,,

So, Internally, their will be sql execution engine for the execution of sql queries, if so can we write sql functions like date functions,upper etc ?.

Regards

ramesh

[shree909]

Yes u can write the upper  and date functions same way as u do in sql..

[MayilVahanan]

HI

Yes. You can use sql queries in qv n exceute. For better performance, Load the data in qvd , to avoid connection each time to sql engine

[#6]

Thanks all of you for your great response

Regards,

Ramesh