CA Log Analyzer returns message LAE0389E unsupported SQL SUBSTR in extended where clause


Article ID: 106789


Updated On:


CA-24X7 High-Availability Manager for DB2 for z/OS CA-Batch Processor Compile QQF CA Data Compressor for DB2 for z/OS Data Navigator for DB2 UDB for z/OS CA-DB Delivery for DB2 CA Unicenter NSM CA Log Compress DBA for DB2 Guide Online CA InfoRefiner Advantage InfoRefiner Advantage InfoRefiner Maint Upgrade CA InfoTransport Advantage InfoTransport Maint Upgrade Online Reorg for DB2 for z/OS CA RC/Update for DB2 for z/OS Query Analyzer RI Editor for DB2 for z/OS DB2 TOOLS- DATABASE MISC


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 ) 


Component: PLA


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