Links

MSCEWI1043

Translation for expression not supported.

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 PUBLIC.EXAMPLE ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
// Helpers and additional code...
let C1 = new CURSOR(`SELECT * FROM PUBLIC.TABLE_DATE`,() => []);
let VAR1;
C1.OPEN();
while ( C1.NEXT() ) {
let REC1 = C1.CURRENT;
if (null /*REC1.COL1*/ /*** MSC-ERROR - MSCEWI1043 - TRANSLATION FOR EXPRESSION 'REC1.COL1' IS NOT SUPPORTED YET ***/ == VAR1) {
VAR1 = 123;
}
VAR1 = null /*REC1.COL1*/ /*** MSC-ERROR - MSCEWI1043 - TRANSLATION FOR EXPRESSION 'REC1.COL1' IS NOT SUPPORTED YET ***/;
}
C1.CLOSE();
$$;

Recommendation