MSCEWI1025

Binding time variables might require a change in query.

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

Severity

Low

Description

The action of binding time variables might require changes in the query that contains them.

Example Code

Input Code:

CREATE PROCEDURE P_1025()
BEGIN
  ...  
  DECLARE LN_EMP_KEY_NO_PARAM NUMERIC DEFAULT -1;
  DECLARE FLOATVARNAME FLOAT DEFAULT 12.1;
  DECLARE hErrorMsg CHARACTER(30) DEFAULT 'NO ERROR';
  DECLARE CurrTs TIME DEFAULT CURRENT_TIME;
  DECLARE CurrTs2 TIME DEFAULT CURRENT_TIMESTAMP;
  ...
END;

Output Code:

CREATE OR REPLACE PROCEDURE P_1025()
  RETURNS STRING
  LANGUAGE JAVASCRIPT
  EXECUTE AS CALLER
  AS
  $$
    ...
    var LN_EMP_KEY_NO_PARAM = -1;
    var FLOATVARNAME = 12.1;
    var HERRORMSG = `NO ERROR`;
    var CURRTS = new Date() /*** MSC-WARNING - MSCEWI2042 - BINDING TIME VARIABLE MIGHT REQUIRE CHANGE IN QUERY. ***/;
    var CURRTS2 = new Date();
    ...
  $$;

Recommendations

• No additional user actions are required.

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