What is the PF filename for AS/400 user profile?

[thsiow]

May i know what is the physical filename for AS/400 User Profile? i need to use the SQL to extract the user profile information such as text(user id real name), password interval ...... into excel file.

the file store in QSYS or QUSRSYS library?

[kuempi]

Re: What is the PF filename for AS/400 user profile?

May i know what is the physical filename for AS/400 User Profile? i need to use the SQL to extract the user profile information such as text(user id real name), password interval ...... into excel file.

the file store in QSYS or QUSRSYS library?

No chance - forget it.
You have just some API like QSYRUPWD or QSYSUPWD to have "some" ways of influence but this is limited.
So have a look to the API-Finder on IBM-Pages.
Or use some CL to find your info for e.g. DSPUSRPRF DSPAUTUSR and so on.

kuempi

[ReachKrishna]

Re: What is the PF filename for AS/400 user profile?

You can use the following command.

DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(QTEMP/TEMP1) 

Once this command runs you will have all the req info on user profiles in the file TEMP1 file in QTEMP lib.