Previous Topic: SQL SELECT in CRTOBJNext Topic: Current SQL SELECT Implementation


SQL SELECT Before Release 5.2

EXEC SQL                               
     SELECT * INTO                     
          :ABABCD,                     
          :ABADCD,                     
          :ABABST,                     
          :ABABDT                      
          FROM ORDL0                   
          WHERE  (  ABABCD = :ABABCD  )
 END-EXEC                              

In Release 5.2, the SELECT was rewritten as follows to avoid overwriting current values of the host variables belonging to the view.