I have a doubt in VSAM. It would be really helpful if some one can help me with that.
I got a VSAM file (say A) with first 48 characters as key. There is an alternate path created for this VSAM (say B) with fields 33-42 (10 digit field as key) as key. I am writing a program where I must use path B as I have to query on that 10 digit field. (I can directly use VSAM file A but it is going to take lot of time to process all records). That 10 digit field has alphanumeric values WITH DUPLICATES. In my program, I have a input value. I need to read this path B with 10 digit key >= Input-key.. My intention is to retrieve multiple records from VSAM satisfying the criteria.. Please let me know how to do it.. Not sure if it is possible to do also..
Yes. I did understand. Initially I was assuming STATUS-CODE shouldn't be '02' when we use START & READNEXT. Now I am clear that when we read sequentially from a particular point in this case, status '02' is a valid possible code that comes because of duplicate keys. So, we can read all records next using status code '00' or '02'. Let me know if I have understood anything wrong.
It is worth noting that the first digit of the file status code being a zero means that the operation was successful, even though the second digit can be 0, 2, 4, 5, or 7 to denote various conditions that did not prevent the operation but could impact the results.