Change User Profile Text Description via SQL...?

[Viking]

I need to mass change part of the text description on a bunch of user profiles...

I can output all user profiles to a file and then programmatically loop through and do a CHGUSRPRF to replace the specific characters of the text description that I need to update for each user profile that meets my criteria.

But is there a better way? Can I somehow use SQL?

[TedHolt]

In IBM i Services, there's a view that will let you retrieve information about a single user profile.

https://www.ibm.com/docs/en/i/7.4?topic=services-user-info-basic-view

I would be surprised if you can use this to change a user profile.

I didn't see a service to return a list of user profiles. That doesn't mean there isn't one.

[MartinTosney]

If you're on a recent Technology Refresh, you could combine the view that Ted mentions with the QCMDEXC scalar function, described here:

https://www.rpgpgm.com/2021/06/qcmdexc-scalar-function-added-to-sql.html

[Viking]

I used SQL to identify the user profiles to target (using QSYS2.USER_INFO) and to decide the new text descriptions for each one, and wrote them to a table. Then I wrote a CLLE to loop through the table and change the text using CHGUSRPRF. It was short and very easy.

But I like the QCMDEXC scalar function Martin mentions above and it looks like I could have used that to do it all in the SQL statement. Thanks for posting the link to that article!