Home > IT Answers > AS/400 > AS/400 User Profile – need to get a file of current user profiles
GwendolynBass
0 pts.
 AS/400 User Profile – need to get a file of current user profiles
AS/400
Does any one know how to access the file that contains all users profiles or how to create one. I know this is a system file but not sure if we are able to access it. I printed out a listing but I really need a file. Thank you in advance - Gwendolyn

Software/Hardware used:
ASKED: December 7, 2006  1:04 PM
UPDATED: December 8, 2006  8:48 AM
RELATED QUESTIONS
Answer Wiki:
Prompt the DSPUSRPRF command and you will note that you can specify *ALL and further redirect the output to an *OUTFILE
Last Wiki Answer Submitted:  December 7, 2006  1:15 pm  by  CarterC19   220 pts.
All Answer Wiki Contributors:  CarterC19   220 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

All you need to do is do the run this command DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(mylibl/myfile)

Imazing
 0 pts.
 

I use this :

DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/USERTEMP)

along with some SQL queries to clean up our user file. If you need a more permanent copy of the file put it somewhere other then QTEMP

MODMOD
 0 pts.
 

That command works great, just remember that it creates an outfile at that point, so if you go back to that file weeks later it will not be a current copy, you would have to do the command again to refresh the data to pick up any changes to the file.

ATitus
 85 pts.