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

      Hi,

       

      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

       

      SELECT COL1 FROM <SCHEMA>.<METADATANAME>

       

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

       

      Thanks