Significance of where 1=1 ?

[Anonymous]

Example:

                mapping Load distinct

                 col1,

                col2

  from abc.qvd

where 1=1

i came across a script in the above format,

Could some one explain the significance of where 1=1

B~

[erichshiino · Accepted solution]

In some versions, some operations reading qvds generated erros when there was no operation in a field or a where clause. QlikView would use the optimized read and the operation would fail.

I`m almost sure that mapping was one of this cases.

So, we used the where 1=1 to avoid the optimized read and make it work

Hope this helps,

Erich

[Anonymous]

in version 10 is it necessary to use where 1=1 or is it fine if its not used ?

B~

[erichshiino]

I`m sorry, but I will not be able to try it on version 10 right now.

If I remember correctly you would get an error message when you had the problem.

[Anonymous]

oh..thank u Eric ..appreciate ur help

B~

[rwunderlich]

It's not necessary in V10.