topic SQL Select in QlikView

SQL Select

mikecrengland — Wed, 25 Nov 2020 16:16:04 GMT

Hello All -

Is there any difference between these two statements (the SQL being the difference):

Load

;

Select

From dbo.table

;

Load

;

SQL

Select

From dbo.table

;

Does having the SQL in the statement change how it behaves?

Thanks!

mike

Re: SQL Select

swuehl — Wed, 25 Jan 2017 14:41:12 GMT

Both work the same.

You don't need to use SQL before the SELECT.

edit: From the old help pages:

The syntax:

SQL SELECT * from tab1;

is allowed, and will in future documentation be the preferred syntax for Select (SQL), for reasons of consistency. The SQL prefix will, however, remain optional for select statements.

Re: SQL Select

mikecrengland — Wed, 25 Jan 2017 14:41:54 GMT

Thanks!

Re: SQL Select

Anonymous — Wed, 25 Jan 2017 14:50:42 GMT

The syntax that you used looks correct. The use of SQL is basically to issue SQL database command like calling a stored procedure or an SQL function. Also an update statement given a correct connection mode.

Really to what you are showing, it will not make much difference, However the usage of an SQL command is more than just selecting records.

Please refer to the help file to get more info.

I hope this helps.