MSCEWI3038

Search clause removed from the with element statement.

Severity

Low

Description

SEARCH clause was removed from the WITH statement.

Example Code

Input Code:

WITH dup_hiredate(eid, emp_last, mgr_id, reportLevel, hire_date, job_id) AS 
(SELECT aValue from atable) SEARCH DEPTH FIRST BY hire_date SET order1 SELECT aValue from atable;

Output Code:

WITH dup_hiredate(eid, emp_last, mgr_id, reportLevel, hire_date, job_id) AS
 (SELECT aValue from PUBLIC.atable) /*** MSC-WARNING - MSCEWI3038 - SEARCH CLAUSE REMOVED FROM THE WITH ELEMENT STATEMENT ***/ SELECT aValue from PUBLIC.atable;

Recommendation