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:
whenever sqlerror exit
MERGE INTO &1..TOSI_REQ_PROSPECCION T
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
WHEN NOT MATCHED THEN
This can be found under the SQLfile in the attachments and the statements file of the table.
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.
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.