TPT DDL Merge Into. How to report rows inserted / updated

Tools
Teradata Employee

TPT DDL Merge Into. How to report rows inserted / updated

Hello.

We are using Merge into in a TPT DDL to load data to the destintation tables.

Our problem is how to report the number of rows inserted/updated by the merge into sentence, because we cant use (or if its possible, we dont know how) notify in DDL Operator.

Please if you have done this before, can you share an example?

Thanks

Tags (4)
1 REPLY
Teradata Employee

Re: TPT DDL Merge Into. How to report rows inserted / updated

Did you look into the log of the DDL operator to see if those statistics are reported?

-- SteveF