CA Log Analyzer returns message LAE0389E unsupported SQL SUBSTR in extended where clause
book
Article ID: 106789
calendar_today
Updated On:
Products
CA-24X7 High-Availability Manager for DB2 for z/OSCA-Batch ProcessorCompile QQFCA Data Compressor for DB2 for z/OSData Navigator for DB2 UDB for z/OSCA-DB Delivery for DB2CA Unicenter NSMCA Log CompressDBA for DB2Guide OnlineCA InfoRefinerAdvantage InfoRefinerAdvantage InfoRefiner Maint UpgradeCA InfoTransportAdvantage InfoTransport Maint UpgradeOnline Reorg for DB2 for z/OSCA RC/Update for DB2 for z/OSQuery AnalyzerRI Editor for DB2 for z/OSDB2 TOOLS- DATABASE MISC
Issue/Introduction
Executing CA Log Analyzer for DB2 for z/OS (PLA) utilizing a table Extended Query Facility (EQF) when a subset of a column has changed.
Encountering the following when a SUBSTR is specified within the EQF query:
LAE0389E Unsupported SQL function detected. The Log Analyzer Select Processor does not support:
SUBSTR ( column_name, 13 , 1 )
Environment
Release: Component: PLA
Resolution
CA Log Analyzer for DB2 for z/OS does not support the following SQL constructs:
- Subselects - Column functions - Joins - Labeled durations - Unions - Host variables - Special registers - GROUP BY clause - Scalar functions - HAVING clause - Concatenation or arithmetic operators - ORDER BY clause