CMS Application - Reference Pattern Search String - Information - How to activate SQL traces in Search string
Purpose
This page explains how to activate SQL traces in Search String.
Applicable in CAST Version
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS | ✅ |
Details
SHOW SQL mode can be activated for Search String by adding - Show(SQL) at the end of the command line of the anarun.
Steps to activate:
Run the Reference Pattern search string. Once the Run Reference Pattern search string has started, cancel it.
Open the CAST MS log file that is in CAST Management Studio - Information - How to find logs - CastMS Log File
Search for the statement “starting Task Run Reference Pattern Search String”. The command line that has been executed to run the reference pattern search string is just below this statement :
Copy the command line.
After anarun, add -SHOW(SQL)
Run the complete command line as below screenshot :
Notes/comments
Related Pages