RE: Not keying physical files

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
DSPFD FILE(ROB/ARLEENL)
Access Path Description
  Access path maintenance . . . . . . . . . . : MAINT      *IMMED
  Unique key values required  . . . . . . . . : UNIQUE     Yes
  Select/omit specified . . . . . . . . . . . :            No
  Access path journaled . . . . . . . . . . . :            No
  Access path . . . . . . . . . . . . . . . . :            Keyed
  Number of key fields  . . . . . . . . . . . :              1
  Record format . . . . . . . . . . . . . . . :            ARLEENR
    Key field . . . . . . . . . . . . . . . . :            MYKEY
      Sequence  . . . . . . . . . . . . . . . :            Ascending
      Sign specified  . . . . . . . . . . . . :            UNSIGNED
      Zone/digit specified  . . . . . . . . . :            *NONE
      Alternative collating sequence  . . . . :            No
    Files accessed by logical file              PFILE
       File               Library              LF Format
       ARLEEN             ROB                  ARLEENR
  Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ     *HEX
  Language identifier . . . . . . . . . . . . : LANGID     ENU
RUNQRY QRYFILE((ROB/ARLEENL))
MYKEY       MYDATA
1           test
2           test
1           test


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Fisher, Don" <Dfisher@roomstoreeast.com>
Sent by: midrange-l-admin@midrange.com
04/24/2002 09:27 AM
Please respond to midrange-l


        To:     "'midrange-l@midrange.com'" <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: Not keying physical files


Are you saying that using a unique key on a logical file always fails or
that it sometimes fails?  I ask because I have tracked duplicate key
errors
to uniquely keyed logical files over physical files without the UNIQUE
keyword or with key fields that were not duplicated by the attempt record
write.

Donald R. Fisher, III
Project Manager
The Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@roomstoreeast.com

<clip>
No it doesn't.  And I've documented cases of this happening.
<clip>
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.