We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Start by posting ideas and requests to this portal to enhance a Power product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas and add comments to ideas that matter most to you
Get feedback from the IBM team to refine your idea
The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The Power teams will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.
Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.
IBM Unified Ideas Portal - https://ideas.ibm.com/ - Use this site to create or search for existing Ideas across all IBM products that are outside of Power, and track all of your personal interactions with all Ideas.
There are already multiple ways to do this today
You can use the IBM i Services
This can also be done with the Web Navigator support.
If you just want to view the user profile, I agree, using the view would be more than enough information without having to use the WRKUSRPRF command.
That being said, most of the time, if we want to work with the user profile, we are looking to change something. That can be done by using sql. The SQL view can by searching and building up the change user profile command and then call qxmdexc.
for example
begin
declare execCommand char( 150 );
FOR cleanup AS userProfiles CURSOR FOR
SELECT 'CHGUSRPRF (' concat authorization_name concat ') status(*disabled)' as command FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'
DO
SET execCommand = command;
call qcmdexc( command );
END FOR;
end;
I would recommend running the select separate to this procedure to verify that you are getting the correct user but, sql can do alot for you.
Yes I know. This is one of the ways to do it. But I still have to copy/paste the userId to another session to do a WRKUSRPRF there. This is not an improvement for me.
Hello.
There is a SQL View to query userprofiles (USER_INFO)
Maybe it could help you to find your profiles
SELECT * FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'
greets
Chris
Hello.
There is a SQL View to query userprofiles (USER_INFO)
Maybe it could help you to find your profiles
SELECT * FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'
greets
Chris
Hello.
There is a SQL View to query userprofiles (USER_INFO)
Maybe it could help you to find your profiles
SELECT * FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'
This is basic functionality in the ADMIN webinterface.
Hi Peder
I know you want this in the 5250 command structure but it is possible to do this today even in the 5250 using IBM i services.
Unfortunately this would mean you writing an SQL wrapper program to carry out the search and pipe the results back to the screen but it would not be complex.
That said, I think you could put together a program to do this quite quickly, so you could have what you want quite quickly
Best wishes SteveB