topic Section Access Where Clause in QlikView

Section Access Where Clause

Rehan — Wed, 15 May 2019 17:32:04 GMT

I have a section access script . what is the purpose of Directory and "Where 1=1" in this ?

SECTION ACCESSS;

Directory;

Load

NTNAME,

KEY,

ACCESS

FROM AB.QVD

WHERE 1=1;

SECTION APPLICATION

Re: Section Access Where Clause

Anil_Babu_Samineni — Thu, 16 May 2019 05:39:17 GMT

Directory can read the table structure default while fetch some columns from source. But, Not necessary to use. Where as 1=1, commonly used when variables are used to generate the SQL statement. 1=1 avoids a syntax error when you want no clause