Error in the syntax of the SQL in TDM merge scripts

Document ID : KB000110132
Last Modified Date : 10/08/2018
Show Technical Document Details
Issue:
When a table has only 2 or 3 columns that are a compound primary key (PK), the SQL of the table generates errors like "missing set statement" when a merge script is executed. 

Checking the generated SQL shows in the UPDATE statement "UPDATE SE". In these cases the tool should instead generate an INSERT or omit the UPDATE. 

This is an example the generated.SQL: 
_____________________________________________________________________________________ 
SPOOL merge_SUBSET_RENTAS_REQUISITOS_06_OPS$OSIRISW_TOSI_REQ_PROSPECCION.lst 
whenever sqlerror exit 
MERGE INTO &1..TOSI_REQ_PROSPECCION T 
USING ( 
SELECT * 
FROM &2..TOSI_REQ_PROSPECCION) S 
ON (T.CDCOMPANIA = S.CDCOMPANIA 
and T.NMPROSPECCION = S.NMPROSPECCION 
and T.NMSEC_REQ_MVTO = S.NMSEC_REQ_MVTO 

WHEN MATCHED THEN 
UPDATE SE 
WHEN NOT MATCHED THEN 
INSERT ( 
T.CDCOMPANIA, 
T.NMPROSPECCION, 
T.NMSEC_REQ_MVTO) 
VALUES ( 
S.CDCOMPANIA, 
S.NMPROSPECCION, 
S.NMSEC_REQ_MVTO); 
exit 
_____________________________________________________________________________ 

This can be found under the SQLfile in the attachments and the statements file of the table. 
Environment:
TDM 4.5
Resolution:
This has been fixed in SUBSET03AUGUST2018.zip.  Please contact CA Support for this or a later release.  Please contact CA Support to verify that this fix made it into the GA Release after August 5, 2018.
Additional Information:

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html