I have to admit when I read that a SQL table function to change user profiles had been introduced in the latest Technology Refreshes for IBM i 7.4 and 7.3 I was skeptical as to whether it was something that I would find practical and useful. Having had some time to play with it I can now appreciate its usefulness.
But before I get to that, let me explain how the CHANGE_USER_PROFILE table function works.
The table function will only change certain information of a user profile. The parameters you can change are: