d5b6992a   
   From: srielau@ca.ibm.com   
      
   > SELECT f(c2) AS c1, f(c1) AS c2 FROM Foobar;   
   > That is why such nonsense is illegal syntax.   
   OK, you made me sweat there for a split second because you violated your   
   own golden rule by not providing DDL:   
   CREATE TABLE foobar(c1 INTEGER);   
   or   
   CREATE TABLE foobar(c2 INTEGER);   
      
   Of course   
   CREATE TABLE foobar(c1 INTEGER, c2 INTEGER)   
   will work just fine.   
      
   --   
   Serge Rielau   
   SQL Architect DB2 for LUW   
   IBM Toronto Lab   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)