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:  

Argument Description
sql_command A valid SQL command.

Example 1:  

SQL leave;

Example 2:  

SQL Execute <storedProc>;

See also:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?