topic Significance of where 1=1 ? in QlikView

Significance of where 1=1 ?

Anonymous — Wed, 21 Dec 2011 19:21:34 GMT

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

Significance of where 1=1 ?

erichshiino — Wed, 21 Dec 2011 19:50:47 GMT

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

Re: Significance of where 1=1 ?

Anonymous — Wed, 21 Dec 2011 20:03:40 GMT

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

Significance of where 1=1 ?

erichshiino — Wed, 21 Dec 2011 20:12:34 GMT

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.

Re: Significance of where 1=1 ?

Anonymous — Wed, 21 Dec 2011 20:21:04 GMT

oh..thank u Eric ..appreciate ur help

Significance of where 1=1 ?

rwunderlich — Wed, 21 Dec 2011 20:42:45 GMT

It's not necessary in V10.