I am trying to write a query from SSIS to pull data from DB2. I know that db2 does not like joins and I need to join into another table to pull the information by date. Below is an example of the query that i am pulling that works for SQL Server. Does someone know the correct syntax for db2.
FROM t1 INNER JOIN
t2 ON t1.emp_ID = t2.empid_ID
WHERE (t2.END_DT BETWEEN DATEADD(dd, - (DAY(DATEADD(mm, 1, GETDATE())) - 1), DATEADD(mm, 0, GETDATE())) AND
DATEADD(dd, - DAY(DATEADD(m, 1, GETDATE())), DATEADD(m, 1, GETDATE())))