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:

  • CRTSQLCBL - Create SQL COBOL Program
  • CRTSQLCBLI - Create SQL ILE COBOL Object
  • CRTSQLCI - Create SQL ILE C object
  • CRTSQLCPPI - Create SQL ILE C++ Object
  • CRTSQLFTN - Create SQL FORTRAN Program
  • CRTSQLPKG - Create SQL Package
  • CRTSQLPLI - Create SQL PL/I Program
  • CRTSQLRPG - Create SQL RPG Program
  • CRTSQLRPGI - Create SQL ILE RPG Object

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.

Last Modified On: April 25, 2018