Re: Utility or SQL that identifies whether a file or dependents have UNIQUE keys defined?

On Wed, 2016-12-07 at 17:51 -0500, Rob Berendt wrote:

http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatkeycst.htm
http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatsyskeys.htm

Wow, there is a whole world of information "hidden"(1) within the SQL
stuff. It sure beats doing a couple of dspfd's and reading/processing
the results.

(1) To those of us who are still catching up on years worth of additions
and/or have rarely dipped out toes into SQL - especially the meta-data
tables.

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: Dan <dan27649@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/07/2016 05:48 PM
Subject: Utility or SQL that identifies whether a file or
dependents have UNIQUE keys defined?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Before I reinvent the wheel in case it's already been invented, I need a
utility or query that will take as input a file name (can limit to
physicals, but would be nice to be able to specify a logical file) and
return a list of files (physical and dependent logicals) that have UNIQUE
keys *and* have no select/omit. The bonus would be list the key fields as
well, but that's a wish list item.

At the present time, I need to check thirty physical files for unique
keys. For those that don't have unique keys, I need to check all of the
dependent logicals for unique keys. After reviewing the first 3 physical
files, I'm already up to having to check 40 logicals, and there's no
reason
to believe the remaining 27 physical files will show a downward trend in
the number of dependent logicals. The potential exists that I will need to
repeat this process in the future.

Thanks,
- Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD