Created
January 31, 2020 14:09
-
-
Save ghitti/5b43fe21a372002d8b9b9fd397ed6e5d to your computer and use it in GitHub Desktop.
Which files in a library, are journaled?
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH FILES( | |
objLib, | |
objName, | |
objSize, | |
objText, | |
journalLibrary, | |
journalName) | |
AS ( | |
SELECT OBJLIB, | |
OBJNAME, | |
OBJSIZE, | |
OBJTEXT, | |
JOURNAL_LIBRARY, | |
JOURNAL_NAME | |
FROM TABLE (QSYS2.OBJECT_STATISTICS('library#1','*ALL') ) AS X | |
WHERE X.JOURNALED = 'YES' | |
AND X.OBJTYPE = '*FILE' | |
UNION ALL | |
SELECT OBJLIB, | |
OBJNAME, | |
OBJSIZE, | |
OBJTEXT, | |
JOURNAL_LIBRARY, | |
JOURNAL_NAME | |
FROM TABLE (QSYS2.OBJECT_STATISTICS('library#2','*ALL') ) AS X | |
WHERE X.JOURNALED = 'YES' | |
AND X.OBJTYPE = '*FILE' | |
UNION ALL | |
SELECT OBJLIB, | |
OBJNAME, | |
OBJSIZE, | |
OBJTEXT, | |
JOURNAL_LIBRARY, | |
JOURNAL_NAME | |
FROM TABLE (QSYS2.OBJECT_STATISTICS('library#3','*ALL') ) AS X | |
WHERE X.JOURNALED = 'YES' | |
AND X.OBJTYPE = '*FILE' | |
) | |
SELECT * | |
FROM FILES | |
ORDER BY | |
objLib, | |
objName; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment