MSCEWI1043

Translation for expression not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

This error is used when a specific expression from the source code is not being converted yet but is planned to be delivered in the future.

A null value is inserted to take the expression's place.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE EXAMPLE()
IS
  CURSOR C1 IS SELECT * FROM TABLE_DATE;
	VAR1 INTEGER;
BEGIN
    FOR REC1 IN C1 LOOP
		IF (REC1.COL1 = VAR1) THEN
			VAR1 := 123;
		END IF;
		    VAR1 := REC1.COL1;
    END LOOP;
end;

Output Code:

CREATE OR REPLACE PROCEDURE EXAMPLE ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // Helpers and additional code...
  let C1 = new CURSOR(`SELECT * FROM
      TABLE_DATE`,() => []);
  let VAR1;
  C1.OPEN();
  while ( C1.NEXT() ) {
    let REC1 = C1.CURRENT;
    if (REC1.COL1 == VAR1) {
      VAR1 = 123;
    }
    VAR1 = REC1.COL1;
  }
  C1.CLOSE();
$$;

Recommendations

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