Hi All,

I created VSAM BATCH CDC Solution with multiple tables and each table data can be filtered based on the TABLE_ID.
Now i have VSAM file which will have data of 50 tables each table with different data. I tried to apply filters in "FILTER ESPRESSION" with say $$$.TABLE_ID = '001' etc for 50 tables. (Here TABLE_ID changes for each table so FILTER EXPRESSION is different).

Problem:

While executing SELECT query to fetch records based on TABLE_ID, Query fetching data without considering TABLE_ID in FILTER EXPRESSION. I tried to query data against _AG (agent).

SELECT * FROM SAM_TBLMAINT:TBLMAINT_DATA WHERE TABLE_ID = '001' LIMIT TO 10 ROWS

This Query is giving first 10 rows of VSAM file.

Is there anyway to get data based on TABLE_ID. or FILTER make work.

Your response is appreciable.

Thanks,
Robert Immanuel.