MSCEWI3038
Search clause removed from the with element statement.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated