Can a wildcard value be used in a Sysview for DB2's IQL WHERE statement?
Article ID: 185365
CA Bind Analyzer for DB2 for z/OSCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OSCA Database Management for DB2 for z/OS - Performance SuiteCA Database Management for DB2 for z/OS - SQL Performance SuiteCA Detector for DB2 for z/OSCA-Insight Performance Monitor for DB2 UDB for z/OS
This document states whether or not a wildcard value be used in a Sysview for DB2's IQL WHERE statement.
Release : 19.0
Component : CA Insight Database Performance Monitor for DB for z/OS
Currently, a wildcard value cannot be used in a Sysview for DB2 IQL WHERE statement. However, a combination of the WHERE & AND operators can be used to select a range of data. For example, to select all Workstations on the History file that begin with L5, you can code the following in the IDB2RWJ job:
//DBGIN DD * GLOBALS WHERE ENDUSER-WORKSTATION-VAR >= 'L5.........' AND <= 'L5999999999' ;
Note: ENDUSER-WORKSTATION & ENDUSER-WORKSTATION-LONG can also be used.