The below works in SQL Server but need it in DB2. Looking for two dates - last Sunday of previous month and last Saturday of current month.
SELECT DATEADD(day, DATEDIFF(day,'1900-01-07', DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE() - 30),30))/7*7,'1900-01-07') AS LAST_SUNDAY_PREVIOUS_MONTH
SELECT DATEADD(day, DATEDIFF(day,'1900-01-06', DATEADD(MONTH, DATEDIFF(MONTH, 0, Getdate()), 30)) / 7 * 7, '1900-01-06') AS LAST_SATURDAY_CURRENT_MONTH
SELECT DATEADD(day, DATEDIFF(day,'1900-01-07', DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE() - 30),30))/7*7,'1900-01-07') AS LAST_SUNDAY_PREVIOUS_MONTH
SELECT DATEADD(day, DATEDIFF(day,'1900-01-06', DATEADD(MONTH, DATEDIFF(MONTH, 0, Getdate()), 30)) / 7 * 7, '1900-01-06') AS LAST_SATURDAY_CURRENT_MONTH