Log Analyzer returns message LAE0389E unsupported SQL SUBSTR in extended WHERE clause

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

Executing 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 )

Resolution

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