MSCEWI3039

Cycle 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

CYCLE 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) CYCLE hire_date SET is_cycle TO 'Y' DEFAULT 'N'
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 - MSCEWI3039 - CYCLE CLAUSE REMOVED FROM THE WITH ELEMENT STATEMENT ***/
 SELECT aValue from PUBLIC.atable;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]