Skip to main content
SQL

ON THIS PAGE

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:  

SQL arguments
Argument Description
sql_command A valid SQL command.

Example 1:  

SQL leave;

Example 2:  

SQL Execute <storedProc>;

See also

 

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: ampquestions@qlik.com