-- WHERE conditions for tables
-- You can use this file to filter rows transferred for the specified tables

-- You can specify any boolean condition that can be used in a WHERE clause in the source database syntax, including any expressions 

-- Syntax:
-- source_table1, where_condition1;  (do not specify WHERE keyword, use ; to terminate the WHERE clause, you can use newlines and tabs)
-- source_table2, where_condition2;

-- Syntax for partitioned tables (if you want to specify partition filters): 
-- If multiple partition filters are defined, they are combined with an OR condition
-- source_table3, PARTITIONS(list, RANGE([EXCLUSIVE] start | MINVALUE, [EXCLUSIVE] end | MAXVALUE), ...), where_condition3; 

-- For Oracle, DB2 specify fully qualified name in uppercase: SCHEMA.TABLE
-- For Oracle, use TO_DATE function to define the format of datetime literals explicitly

-- Examples (uncomment):
-- SALES.ORDERS, created_dt >= CURRENT_DATE;
-- SALES.ORDERS, created_dt >= TO_DATE('31-DEC-2022', 'DD-MON-YYYY') AND completed = 'Y';
-- SALES.ORDERS, PARTITIONS('CA');
-- SALES.ORDERS, PARTITIONS('CA','NY'), completed = 'Y';
-- SALES.ORDERS, PARTITIONS(RANGE(EXCLUSIVE '2026-05-08', MAXVALUE)), completed = 'Y';
