Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: minor typo correction

In some RPG shops, all programs are compiled with USRPRF(*OWNER) and the owner of all programs is set one specific user profile which has the correct object authority to the database files.No other regular user profiles are granted authority to the files. In this scenario, the SQL service program will not have authority to any files and the query will fail.

The solution is the to change the service program so it also uses adopted authority. This can be done with the following two commands

...