Text portion of the user profile in AS/400
In what AS/400 file does the Text portion of the user Profile get stored?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 16, 2012 9:18 AM
UPDATED:
March 17, 2012 1:24 AM
Answer Wiki:
In AS/400, User profile will be stored as Object of type *USRPRF.
All the user profiles will be created under QGPL.
Text of the User profile can be retrieved, by using the User profile(Object) Description.
Pradeep.
To see all answers submitted to the Answer Wiki: View Answer History.
All the user profiles will be created under QGPL.
Minor correction — User profiles are always created in QSYS, never in QGPL.
The rest is correct. The AS/400 series of systems are object-based. Objects such as user profiles are never found in “files”. Each profile is a separate object.
There are system supplied methods for extracting various object attributes into database files if you want to access attributes that way.
To extract text of almost any object, you can use the DSPOBJD (Display Object Description) command and redirect its output to a database file. Only attributes that are common to all object types (e.g., “text”) is accessible through that command.
To extract attributes that are specific to user profile objects, you can use the DSPUSRPRF (Display User Profile) command. You can also redirect the output from that command to a database file.
Other commands and APIs are available for particular uses. For example, the RTVUSRPRF command could be used in a CL program to retrieve attributes of a specific user profile into variables in the program.
Tom
Oops.. Thanks for correcting Tom..
I was a bit confused.
Pradeep.