DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

[BeatrixKiddo]

Hello, I have been looking for a reference to know which columns you could get running the command:

DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

But not been able to find out the names and order of the columns. Does anyone hase an idea?

 

[lkmalee]

It appears to me that you cannot successfully run this command as written (at lease, you can't on V5R3). It appears that you can only use the *PRINT parameter on a single user profile name i.e.

DSPUSRPRF QPGMR OUTPUT(*PRINT)

You can see the fields generated if you use the *OUTFILE parameter:

DSPUSRPRF QPGMR OUTPUT(*OUTFILE) OUTFILE(MYLIB/MYFILE)

then use a query tool to inspect the output file MYLIB/MYFILE.

Hope this helps.

 

[tcsbiz]

That combinaiton is not valid as explained in the message information for the error you get when you try it:

                         Additional Message Information                        
                                                                               
 Message ID . . . . . . :   CPD22AE       Severity . . . . . . . :   40        
 Message type . . . . . :   Diagnostic                                         
 Date sent  . . . . . . :   08/21/09      Time sent  . . . . . . :   09:36:21  
                                                                               
 Message . . . . :   TYPE and OUTPUT values not valid with USRPRF(*ALL).       
 Cause . . . . . :   USRPRF(*ALL) is valid only when *BASIC is specified for   
   the TYPE parameter and *OUTFILE is specified for the OUTPUT parameter.      
 Recovery  . . . :   Either specify a specific user profile name for the USRPRF
   parameter or change the TYPE value to *BASIC and the OUTPUT value to        
   *OUTFILE.

As lkmalee said, send the data to a file and query the file. You can try each option for TYPE and see what you get. There may be a book on IBM's website that explains the fields.