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

[Jonathan Wilson <piercing_male@xxxxxxxxxxx>]

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