SQL

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

Syntax:  

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.

Arguments:  

Example 1:  

SQL leave;

Example 2:  

SQL Execute <storedProc>;