MSCEWI3077

Semantic information missing for ROWTYPE attribute

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

Severity

Low

Description

This warning is displayed when semantic analysis failed on the referenced table or cursor and the symbol could not be resolved.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE ROWTYPE_DEMO AS
  RECORDROWTYPE TABLE_A%ROWTYPE;
BEGIN
  NULL;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.ROWTYPE_DEMO ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // REGION SnowConvert Helpers Code
   let RECORDROWTYPE = ROWTYPE(`PUBLIC.TABLE_A`) /*** MSC-WARNING - MSCEWI3077 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR TABLE_A ROWTYPE ATTRIBUTE. TABLE ROWTYPE IS ASSUMED. ***/;
   null;
$$;

Recommendations

• If the rowtype record stores a row table the warning can be ignored. Otherwise, if the rowtype stores a cursor row, you have to change the syntax to use Cursor rowtype like CURSOR_VARIABLE.ROWTYPE(). For more information check the documentation related to rowtype.

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