Trying to use the SQL scan function to scan a Stored Proc in SQL Optimizer and its getting stuck at NN%.
It's a complex stored procedure.
"if @CC = 'Y'" is the reason to cause the scan process hanging.
There is a workaound to scan all SQL statements for this stored procedure. You can follow the steps below.
1. open the file proc.sql you have
2. remove the line if @CC = 'Y' and save it
3. launch QSOSS and go to the Scan SQL module
4. click Source Code in Welcome page, or right-click Scaner node in Task page and then select Scan SQL from->Source Code
5. click + in 'Add by file' panel and select the file(proc.sql) you just updated
6. select a connection you want to use for scanning, and change a group name if you want
7. press Finish button and start sanning
8. the scanning process will be completed as expected and all statements within the SP are found.
fix reference number to be implemented in a future release: CR84846
