Skip to content

Instantly share code, notes, and snippets.

@ghitti
Created January 31, 2020 14:09
Show Gist options
  • Save ghitti/5b43fe21a372002d8b9b9fd397ed6e5d to your computer and use it in GitHub Desktop.
Save ghitti/5b43fe21a372002d8b9b9fd397ed6e5d to your computer and use it in GitHub Desktop.
Which files in a library, are journaled?
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