Searching SQL in all Reports: Optimizing Impact Analysis with Blitz Report Queries
Our database team is planning a critical schema change involving a major custom table, ‘XX_CUSTOM_TAB’, and we urgently need to perform a comprehensive impact analysis. The complexity lies in identifying every single custom report, whether standard concurrent program based or defined in a custom reporting tool, that currently queries this table in its underlying SQL definition. Manually reviewing code packages and buried report files is not feasible within our timeframe. Is there an integrated solution allowing for rapid, centralized Searching SQL in all Reports to accurately map table dependencies and streamline our change control process?
7 replies
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.