0 Replies Latest reply on Jan 15, 2021 7:17 PM by Padmanabha G

    SQL Queries in Subset Entity Criteria for Mainframe Files

    Padmanabha G Seasoned Veteran



      I have a  requirement to subset data present in mainframe QSAM/VSAM files using Informatica TDM 10.2.0 HF2. In  the subset entity is it possible to provide SQL queries in the entity criteria for mainframe files? I tried do this but workflow generation failed.

      used below sql query in the criteria




      SQL query for DB2 ZOS tables in entity criteria is working fine, however, looking for similar option for mainframe files.