ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
CA Log Analyzer returns message LAE0389E unsupported SQL SUBSTR in extended where clause
Article ID: 106789
Updated On:
Products
24X7 High-Availability Manager for DB2 for z/OS
Batch Processor
Compile QQF
Data Compressor for DB2 for z/OS
CA Unicenter NSM
RC/Update 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
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
- 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
Feedback
Yes
No
Powered by
