SQL statement of the last month of DB2

SQL CREATE FUNCTION "DB2INST1" in the last month of DB2 ". "QTR" www.2cto.com ("DDATE" DATE) returns character (7) SPECIFIC "DB2INST1 ". "SQL130225092927300" language SQL not deterministic reads SQL DATA STATIC DISPATCH CALLED ON NULL INPUT EXTERNAL ACTION INHERIT SPECIAL REGISTERS BEGIN ATOMIC DECLARE v CHARACTER (7) default ''; -- declare cursor1 cursor for set v = (select case when TO_CHAR (DDATE, 'q') = '1' THEN to_char (year (DDATE)-1) | '-12' when TO_CHAR (DDATE, 'q') = '2' THEN to_char (year (DDATE) |'-03 'when TO_CHAR (DDATE, 'q') = '3' THEN to_char (year (DDATE) | '-06' when TO_CHAR (DDATE, 'q ') = '4' THEN to_char (year (DDATE) | '-09' END -- into: v -- the previous quarter month can know the cross-year from sysibm. sysdummy1 fetch first 1 rows only); -- fetch first 1 rows only -- set sum = a + B; return v; END;