This is a deprecated version of the SnowConvert documentation, please visit the official site .
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;