Get Data Moving 1
Results 1 to 2 of 2

Thread: Vsam data access with multiple structures

  1. #1
    rimmanuel is offline Junior Member
    Join Date
    Oct 2011
    Posts
    3
    Rep Power
    0

    Question Vsam data access with multiple structures

    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.

  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    Please avoid cross-posting.

    As for your question, have you set the environment variable useTableFilterExpressions in the queryProcessor section to True? Without this the expressions would not have any effect.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •