SHOW SQL mode can be activated for TCC by adding -ShowSQL at the end of the command line of the TCC.
Steps to activate:
Create a shortcut for TCC executable from the flat (TCC executable is named CAST-TransactionConfig.exe)
Right click on Windows shortcut for TCC and choose Shortcut. Add '-ShowSQL' to the end of the command line as shown below.
Example: "C:\Program Files (x86)\CAST\7.3.0\CAST-TransactionConfig.exe" -ShowSQL
Launch TCC from the shortcut created to activate SQL traces.
SQL trace will be present in TCC log. If you want to modify TCC log location, please refer to Transaction Configuration Center - Information - How to change the default location of TCC log file