I have a KSAMXL file with the following characteristics:
:LISTF KCROVLP.DATA.ALTTEST,5
********************
FILE: KCROVLP.DATA.ALTTEST
FILE CODE : 0 FOPTIONS: ASCII,FIXED,NOCCTL,KSAMXL
BLK FACTOR: 113 CREATOR : **
REC SIZE: 30(BYTES) LOCKWORD: **
BLK SIZE: 4096(BYTES) SECURITY--READ : ANY
EXT SIZE: 0(SECT) WRITE : ANY
NUM REC: 1102 APPEND : ANY
NUM SEC: 768 LOCK : ANY
NUM EXT: 3 EXECUTE : ANY
MAX REC: 2300 **SECURITY IS ON
FLAGS : NO ACCESSORS
NUM LABELS: 0 CREATED : SUN, APR 28, 2002, 9:21 AM
MAX LABELS: 0 MODIFIED: SUN, APR 28, 2002, 9:21 AM
DISC DEV #: 63 ACCESSED: WED, SEP 4, 2002, 4:32 PM
SEC OFFSET: 0 LABEL ADDR: **
VOLCLASS : TEST_SET:DISC
KEY KEY TYPE KEY LOCATION KEY SIZE DUP/RDUP
--- -------- ------------ -------- --------
1 BYTE 1 8 RDUP
2 BYTE 9 8 NONE
NUM KSAM KEYS: 2 FIRST KSAM RECORD: 0
LANGUAGE : NATIVE-3000 REUSE RECORD : YES
PRIMARY KEY : RANDOM COMPUTE BLK SIZE : DEFBLK
VERSION : 2 DATA BLOCK SIZE : 4096
What this says to me is that there are two keys the 1st of which is a
duplicating key and the second of which is a unique key.
I have always assumed that if you have a unique key that it may not be
repeated within the file at all. But what I have found in this file is that
yes the 2nd key is unique but only within the 1st key. So in essence I have
a duplicate unique key. Is this correct or is something weird happening
here or allowed to happen with in one of the input programs (not written by
me - so I can't say why or where it comes from)?
What I really need to do is resize and sort the data and I usually set up a
script using "Build" and "Suprtool" to clean up ksam's and resize them, but
this time I keep getting messages that the key is duplicated and Suprtool
will not let me create the new file with duplicate data - so at least the
intrinsics don't like the duplicates.
I tried looking in the archives, help and the documents and my take is that
the key that is unique should not be duplicated but what I am really looking
for is confirmation that my knowledge of ksams is correct or here is a twist
that I had not encountered before in using KSAMS.
Appreciate all the help,
Cat
*****************************
Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
[log in to unmask]
www.valleypres.org
www.littenfamily.com
********************************
The thoughts, comments, and opinions expressed herein are mine. They do not
reflect those of my employer, nor anyone else.
********************************
This E-mail is covered by the Electronic Communications Privacy Act, 18
U.S.C. §§ 2510-2521 and is legally privileged. This information is
confidential information and is intended only for the use of the individual
or entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this transmission in error, please notify the sender immediately by return
electronic transmission and then immediately delete this transmission.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|