That query fails due to non-existent columns. The doc references 7.2 & 7.3 enhancements, so I figure that's what's missing.
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Monday, July 24, 2017 8:57 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: How to show journaled objects?
If you just want a count of how many see
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.JOURNAL_INFO%20view
You may also like this:
SELECT OBJLIB, OBJNAME, OBJTYPE, OBJDEFINER,
JOURNALED, JOURNAL_LIBRARY, JOURNAL_NAME, JOURNAL_IMAGES
FROM TABLE(QSYS2.OBJECT_STATISTICS('DGECAMF', '*DTAQ')) AS a;
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.Object_Statistics%20table%20function%20ease%20of%20use
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Rob Berendt <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 07/24/2017 09:45 AM
Subject: Re: How to show journaled objects?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
WRKJRNA JRN(ROB/QSQJRN)
F19=Display journaled objects
Display . . . . 1. Files
2. Access Paths
3. Data Areas
4. Data Queues
5. Integrated File System objects
6. Commitment Definitions
7. Libraries
30. All object types
40. Summary by object type
Rob Berendt
midrange.com
