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/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

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