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 Qlik Sense 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:
| Argument | Description |
|---|---|
| sql_command | A valid SQL command. |
Example 1:
SQL leave;
Example 2:
SQL Execute <storedProc>;