Skip to main content Skip to complementary content


The SQL statement allows you to send an arbitrary SQL command through an ODBC or OLE DB connection.


SQL sql_command


Sending SQL statements which update the database will return an error if QlikView has opened the ODBC connection in read-only mode.

The syntax:

SQL SELECT * from tab1;

is allowed, and is the preferred syntax for SELECT, for reasons of consistency. The SQL prefix will, however, remain optional for SELECT statements.


SQL arguments
Argument Description
sql_command A valid SQL command.

Example 1:  

SQL leave;

Example 2:  

SQL Execute <storedProc>;

Learn more


Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: