MSCEWI1025

Binding time variables might require a change in query.

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]​

MSCEWI1024

MSCEWI1026

Last modified 3mo ago