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/
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.