SQL Implementation › Implementing Restrictor and Positioner Functionality › Example of WHERE Clause Containing OR Logic

Example of WHERE Clause Containing OR Logic

EXEC SQL                                           
     DECLARE MYVIEWCURSOR CURSOR FOR               
          SELECT * FROM MYVIEW                     
               WHERE    KEY1   =   :HOSTVAR1       
               AND    ((KEY2   >   :HOSTVAR2     )
               OR      (KEY2   =   :HOSTVAR2  AND  
                        KEY3   >=  :HOSTVAR3     ))
          ORDER BY      KEY1   ASC,                
                        KEY2   ASC,                
                        KEY3   ASC                 
END-EXEC