User profile settings

5 pts.
Tags:
DSPUSRPRF
IBM iSeries
User profiles
I have the results of: DSPUSRPRF USRPRF(*ALL)in a file, but I need the definition file i.e. the sequens of the informations in the file

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Can you explain what you mean by the definition file? IF you’ve done a DSPUSRPRF *ALL to an output file, the output file should be externally defined.

Regards,

Martin Gilbert.

Command DSPFFD will display or print the field descriptions for the file.
You could also use RUNQRY to display the contents with columh headings.
JSellick

Hi from PGMBOB

Many system commands with outfile parameters will create the file for you WITH an IBM provided data definition.
DSPUSRPRF has several output definitions based on the information requested.

the DSPFFD or SQL can display the format that was created based on your selection. Here is the information from the book.
File to receive output (OUTFILE)

Specifies the database file to which the output of the command is directed. If the file does not exist, this command creates a database file in the specified library. If the file is created, the public authority for the file is the same as the create authority specified for the library in which the file is created. Use the Display Library Description (DSPLIBD) command to show the library’s create authority.

Qualifier 1: File to receive output

name
Specify the name of the database file to which the command output is directed.

Qualifier 2: Library

*LIBL
The library list is used to locate the file. If the file is not found, one is created in the current library. If no current library exists, the file will be created in the QGPL library.
*CURLIB
The current library for the thread is used to locate the file. If no library is specified as the current library for the thread, the QGPL library is used.

name
Specify the name of the library to be searched.

Note: If a new file is created and *BASIC is specified on the Type of information (TYPE) TYPE parameter, the system uses QADSPUPB in QSYS with a format name QSYDSUPB as a model.

If a new file is created and *OBJAUT is specified on the TYPE parameter, the system uses QADSPUPA in QSYS with a format name QSYDSUPA as a model.

If a new file is created and *OBJOWN is specified on the TYPE parameter, the system uses QADSPUPO in QSYS with a format name QSYDSUPO as a model.

If a new file is created and *OBJPGP is specified on the TYPE parameter, the system uses QADSPUPG in QSYS with a format name QSYDSUPG as a model.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following