Important Updates to Cybersecurity Software
HelpSystems is updating the names of our cybersecurity software, including the Powertech product line. Don’t worry—the functionality of your products won’t change.
See the new names here > New, Simpler Names for HelpSystems Security Software.
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 Manager 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 Manager 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.