Home > IT Answers > AS/400 > AS400 libraries
TNKR
105 pts.
 AS400 libraries
AS/400, AS/400 Library
How to get the libraries list that are created by a single user in AS400?

Software/Hardware used:
AS400
ASKED: April 23, 2012  7:48 AM
UPDATED: April 29, 2012  3:04 PM
RELATED QUESTIONS
Answer Wiki:
Try dumping the objects to a file the review with a query. DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*LIB) OUTPUT(*OUTFILE) OUTFILE(QTEMP/LIBS) The created by user field is ODCRTU
Last Wiki Answer Submitted:  April 23, 2012  3:28 pm  by  ToddN2000   4,115 pts.
All Answer Wiki Contributors:  ToddN2000   4,115 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

This command will create a much smaller list. Just use query or SQL to select the libs for a specific owner after the command complete.

DSPOBJD OBJ(QSYS/*ALL)                
        OBJTYPE(*LIB)                 
        OUTFILE(QTEMP/LIBLIST)
WoodEngineer
 5,570 pts.
 

This command will create a much smaller list.

The two lists better be the same size. However, limiting the search space to QSYS could give a faster result.

Tom

TomLiotta
 110,175 pts.
 

Thank you ToddN2000

TNKR
 105 pts.
 

Thank You All

TNKR
 105 pts.