|
View previous topic :: View next topic
|
| Author |
Message |
rackshit
New User
Joined: 19 Dec 2009
Posts: 16
Location: Mumbai
|
|
|
|
Hi,
I have created a VSAM file with following definition
| Code: |
DEFINE CLUSTER(NAME(HLQ.TEST.test.VSAM) -
INDEXED -
KEYS(10 0) -
SPEED -
VOLUMES(DUMMYV) -
RECORDSIZE(128 128) -
SHAREOPTIONS(3 3)) -
DATA(NAME(HLQ.TEST.test.VSAM.DATA) -
CYLINDERS(5 15) -
CISZ(4096)) -
INDEX(NAME(HLQ.TEST.test.VSAM.INDX) CYL(5 5))
REPRO IFILE(SYSUT1) ODS(HLQ.TEST.test.VSAM) ERRORLIMIT(100)
|
the vsam gets created fine. My keys are 10 in length.
now i want to get all the records whose first 6 key field characters are known to me .. the rest 4 characters are not know to me.
So i want to do a get next sort of thing after initialising with first 6 characters of the field and then doing get next to get all the records which start with those 6 characters.
Will moving low values to the next 4 characters and doing start help ? if not then how this can be achieved. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Use SKIP SEQUENTIAL.
Find the first key that matches pos 1-6 and then use sequential from that point on.
I assume that you have read manuals and googled |
|
| Back to top |
|
|
|
|
