View previous topic :: View next topic
|
Author |
Message |
dipanshu
New User
Joined: 16 Jan 2006 Posts: 53 Location: pune
|
|
|
|
Hi All,
Can we search a file in random mode on the basis of Partial key.
Say the key length in Vsam file is of 40
and I only want to search for the last 10 characters of the key
ie move '0123456789' to key(31:10)
read <file1>
It it possible
Thanks,
Dipanshu |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
Dipanshu.
I believe the only way to do that is to define a secondary key for that location.
Dave |
|
Back to top |
|
|
shivani_tech Warnings : 2 New User
Joined: 08 Jan 2006 Posts: 22 Location: UNITED KINGDOM
|
|
|
|
ya only with the help of alternate key...........we can solve out this. |
|
Back to top |
|
|
dipanshu
New User
Joined: 16 Jan 2006 Posts: 53 Location: pune
|
|
|
|
Hi shivani,
Many thanks 4 reply,
Could u or anyone please elaborate the above reply.
Thanks Dipanshu |
|
Back to top |
|
|
sreenivas_kommana
New User
Joined: 11 Apr 2006 Posts: 1
|
|
|
|
alternate key on vsam is Alternate Index.
Define AIX on your VSAM file. Find below the format:
EXAMPLE.AIX - your alternate index
EXAMPLE.KSDS2 - your base VSAM file
//DEFAIX1 JOB ...
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=A
//SYSIN DD *
DEFINE ALTERNATEINDEX -
(NAME(EXAMPLE.AIX) -
RELATE(EXAMPLE.KSDS2) -
MASTERPW(AIXMRPW) -
UPDATEPW(AIXUPPW) -
KEYS(3 0) -
RECORDSIZE(40 50) -
VOLUMES(VSER01) -
CYLINDERS(3 1) -
NONUNIQUEKEY -
UPGRADE) -
CATALOG(USERRCAT/USERUPPW)
/*
NOTE: You can refer the below link for more help.
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt1v403/CCONTENTS
-kommana |
|
Back to top |
|
|
|