Register Hereor login if you are already a member
I've written a similar program. If you use the command, DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(USERFILE) This places all of the user profile data into a spreadsheet, It doesn't include the password, of course. Once the data is in the file, you can pull the fields that you need via SQL or program. This command has to be run with a user id with the *sysadmn authority.