I have a list of SQL statements extracted from ETL jobs (IBM Data Stage) and each statements is identified with single line SQL comment before the body of the SQL: e.g.
/* Job 123ABC */
Select sysdate from dual;
I am using the Scan SQL feature and want to know if:
1. is there is a way to import this comment with the SQL so they can link the results from SQL optimization to which job the ETL developers need to work on?
2. The other option is if we can modify the default SQL naming from 'SQL 9', 'SQL 10', etc. from the SQL list to something that includes our comment plus unique number suffix?
Our DEV team has confirmed that SQL Optimizer currently does not support scanning SQL with comments in the Scan SQL module, and the SQL List in Scan SQL is non-editable now.
A ST98304 has been created for future enhancement consideration of adding feature/option to allow scanning comment with the SQL, or allow user to editing SQL names/ adding comments to each SQL scanned.