Re: Primary key

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

WRKPFCST will show you the primary key, as well as referential and other 
unique key constraints associated with a PF. These are all different from 
the key that a PF can have when created with DDS. A PF can have multiple 
indexes this way, that are not separate LF objects.

At 08:20 PM 3/19/2004 -0600, you wrote:
> At 15:40 3/19/2004, Alan Kincer wrote:
> > Can anyone tell me how to identify the primary key of a physical file?
>
> The easy out is dspfd <filename> type(*accpth). That's probably not what 
> you had in mind though, because a logical view (index) can be created with 
> the keyword UNIQUE, meaning that each key in the index must be exactly 
> that. If that's your quandry, I can sympathize, but afaik, you're stuck 
> with looking at each index (dspdbr) and recording the key attributes in a 
> spreadsheet or something. You could easily have more than one unique key.
>
> Pete Hall
> pbhall@xxxxxxxxxxxxx
> http://www.pbhall.us/