WITH TEMP(N) AS 
   (SELECT 1 FROM SYSIBM.SYSDUMMY1 
    UNION  ALL 
    SELECT N+1 
    FROM   TEMP 
    WHERE  N < 10) 
  SELECT N 
  FROM TEMP;