Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Rehan
Creator III
Creator III

Section Access Where Clause

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

 

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful