When you want a dynamic SQL statement to adopt, you must specify *OWNER for the Dynamic user profile attribute when compiling the program. Then within Policy Minder for IBM i, you may want to have an object template that names the programs that contain dynamic SQL so that you can ensure that those programs' dynamic user profile attribute are set correctly. Or you may want to specify the dynamic user profile setting when compiling any program that can have dynamic SQL, regardless of whether it actually contains dynamic SQL. The commands that allow you to specify the Dynamic user profile attribute include:
Use Policy Minder for IBM i's Analyze SQL Information (SKYVIEWPMP/ANZSQLINF) command to find all programs containing dynamic SQL.
Still have questions? We can help. Submit a case to Technical Support.