Finding SQL using incompatible functions is easy with static SQL as the package and the statement number is provided, but it is difficult for dynamic SQL.
This Rexx captures IFCID 366/376 and for each SQL statement returned , it reads IFCID 317 to get the full sql text in the case of dynamic SQL.
Last update : 27/05/2020
Get the rexx here : https://github.com/ndt98/Db2z/blob/master/ifc376f.rex
No comments:
Post a Comment