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
midrange.com
