Re: DSPFFD utility

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

I found it, it was squirreled off way to the right and hidden unless you
scroll to just the correct location. It is under Schemas -> Table -> Work
with -> Indexes. Scroll right until you find it, not too far though. Or
change the default columns in that view to bring the relevant columns far
enough left to see it without scrolling. It even tells you the type of
index, and Unique/FIFO/LIFO/etc.

On Tue, Aug 6, 2019 at 2:18 PM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

> I have DDS PFs that looks like that, that do show keys in iACS.  It turns
> out some devs use iNav to add columns to existing DDS PFs.  Apparently
> that's enough to make the keys visible to iACS (and presumably iNav).
>
> Sorry for the misleading posts.
>
>
>
> -----Original Message-----
> From: Rob Berendt [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, August 06, 2019 1:01 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: RE: DSPFFD utility
>
> To summarize:
> If you have DDS like the following:
>                             UNIQUE
> R ABR
>   MYKEY         11A
>   MYDATA        10A
>   MYDATE          L
> K MYKEY
>
> And you use iACS to look at it.
> 1-You will not see any constraint on it.  Primary key, unique, or
> otherwise.  Constraints will only show if created with DDL or ADDPFCST.
> 2-However if you right click on it and select Work With, Indexes you will
> see NAME, SYSTEMSCHEMA, TYPE, KEY COLUMNS AB, ROB, Keyed Physical File,
> MYKEY
>
>
> 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
> at amazon.com with our affiliate link: https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://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: https://amazon.midrange.com