INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

(OP)
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?
 

RE: DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

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.

CODE

DSPUSRPRF QPGMR OUTPUT(*PRINT)
You can see the fields generated if you use the *OUTFILE parameter:

CODE

DSPUSRPRF QPGMR OUTPUT(*OUTFILE) OUTFILE(MYLIB/MYFILE)
then use a query tool to inspect the output file MYLIB/MYFILE.

Hope this helps.

RE: DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

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

CODE


                         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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close