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.