Links

MSCEWI2049

TPT-Statement not processed.

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.