Re: Determine if a uniquely keyed logical exists for a given physical

[ron_adams@xxxxxxxxxxxxxx]

Use DSPDBR - Display Database Relations, then use DSPFD over the Logicals 
listed. 


Thanks,

Ron Adams
Information Technology Group
Crane Valves
9200 New Trails Dr. Suite 200
The Woodlands, TX 77385





"Wilt, Charles" <CWilt@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/02/2005 01:56 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     "Midrange Systems Technical Discussion \(E-mail\)" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Determine if a uniquely keyed logical exists for a 
given physical


I've got a physical file that was defined without a unique key.

Is there some way to tell if some logical over that physical has a unique 
key?

Of course I could always do it the hard way:
1) Look at the source or the DSPFD output for every logical
2) Try to write some duplicate records.

But I'm wondering if there's someplace on the system that tracks if a 
physical file has some unique key defined somewhere.

Thanks,


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.