How To Guide

When to Specify a Policy for a Program's Dynamic User Profile Attribute

Last Updated:
March 4, 2017

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
  • 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.

Related Products

Related Solutions