RE: Determine if a uniquely keyed logical exists for a givenphysical

DSPFD will not show logicals, but DSPDBR will. 
If there is a logical that has a key over it, that will be found using 
DSBDBR/DSPFD combination. 
I don't know of any other way to find logicals and their keys unless your 
using DBU or you have the JADA tools or some other util, but they will all 
show the same output/info as DSPDBR/DSPFD. 

Ron Adams





"Wilt, Charles" <CWilt@xxxxxxxxxxxx>
Sent by: midrange-l-bounces+ron_adams=cranevalve.com@xxxxxxxxxxxx
02/02/2005 03:01 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Determine if a uniquely keyed logical exists for a 
givenphysical


I believe that option was included as part of #1 in my original post.



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

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> ron_adams@xxxxxxxxxxxxxx
> Sent: Wednesday, February 02, 2005 3:04 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Determine if a uniquely keyed logical exists for a
> givenphysical
> 
> 
> 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.