Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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