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

Article Id: 106789
Status: Published
Updated On: 16-07-2018 09:54
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