IBM Power Ideas Portal
This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
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:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your 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