MSCEWI2049

TPT-Statement not processed.

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

Severity

High

Description

A DML statement in TPT could not be processed and converted by the tool. This can happen for reasons like using concatenation with script variables or using scaping quotes inside the DML statement.

Example code

Input Code:

STEP stLOAD_FILE_NAME
(
APPLY
('INSERT INTO' || @ScriptVar || '.EMP_NAME
(EMP_NAME, EMP_YEARS, EMP_TEAM)
VALUES
(:EMP_NAME, :EMP_YEARS, :EMP_TEAM);')
TO OPERATOR (ol_EMP_NAME() [1])
SELECT * FROM OPERATOR(op_EMP_NAME);
);
);

Output Code:

   def stLOAD_FILE_NAME(self):
      /*** MSC-WARNING - MSCEWI2049 - THE FOLLOWING STATEMENT COULD NOT BE PROCESSED ***/
      #INSERT INTO' || @ScriptVar || '.EMP_NAME
      #(EMP_NAME, EMP_YEARS, EMP_TEAM)
      #VALUES (:EMP_NAME, :EMP_YEARS, :EMP_TEAM);

Recommendations

• For this issue, you can type the insert statement manually, and/or since the DML statement is not being supported yet, ask the SnowConvert team to add support for that specific case.

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