Re: DSPFFD utility

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