Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Partial Keys

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
rackshit

New User


Joined: 19 Dec 2009
Posts: 16
Location: Mumbai

PostPosted: Fri Mar 18, 2011 11:24 am    Post subject: Partial Keys
Reply with quote

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
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 18, 2011 1:38 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PA02 - Programmtically control attent... dodithegreat IMS DB/DC 1 Thu Apr 06, 2017 8:33 pm
No new posts Joinkeys with duplicated keys juares castro SYNCSORT 19 Fri Sep 23, 2016 5:58 am
No new posts Too many edit macro's and too few PF ... don.leahy TSO/ISPF 7 Wed Feb 17, 2016 3:00 am
No new posts Join Keys and DB2 Query jackare SYNCSORT 2 Sat Feb 13, 2016 5:57 am
No new posts Join Keys to compare two files senthamizh DFSORT/ICETOOL 2 Fri Feb 05, 2016 8:28 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us