Receiving -104 error when attempting to run explain with SRCSQL
search cancel

Receiving -104 error when attempting to run explain with SRCSQL

book

Article ID: 280594

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS

Issue/Introduction

Receiving error in Plan Explain with SRCSQL

SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "=". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: JOIN INNER LEFT RIGHT FULL CROSS , HAVING
GROUP WHERE INTERSECT    

Environment

z/os DB2 V13

Cause

The SQL statement is invalid commas are not permitted

SELECT * FROM SYSIBM.SYSPACKAGE,               
WHERE DATE(BINDTIME) = (CURRENT DATE - 1 DAY)        

Resolution

Remove comma

SELECT * FROM SYSIBM.SYSPACKAGE               
WHERE DATE(BINDTIME) = (CURRENT DATE - 1 DAY)