MVSFORUMS.com

sinduja · Beginner Joined: 20 Jun 2005 Posts: 29 Topics: 14

hi all
Thank you kolusu for your previous replies.
Now in a vsam(KSDS) file ..................
is it possible match for a part of a record key.

my file sectiopn is like this

01 fs-rec.
02 fs-key.
03 fs-id1 pic x(2).
03 fs-level-id pic x(4).
03 fs-cif-id pic x(3).
02 fs-.........
...............

now i want to fetch all records that have fs-level-id = '1608'
and fs-cif-id = '03'

if i move 1608 to fs-level-id and 03 to fs-cif-id and
try to fetch using

read ... invalid key
not invalid key

statement ,i get file status of 23,i.e no matching records inspite of having matching records.

can anyone please tell me what is the solution. (I cannot set an alternate index, and using sequential access is inefficient bcos the file is a large one and the matchin records r goin to be really few.)

thank you.

regards,
sinduja.

kolusu · Posted: Tue Jul 05, 2005 6:36 am Post subject:

sinduja,

You are matching only a part of the key and that too the contents in the middle. Unless you read the entire file you will not be able to read the records directly. you need to read every record and then check starting from the 3rd byte for a length of 6 has '160803'.

If your intention is just to filter out the records then you can simply use SORT utility to get the desired results.

ex:

sinduja · Beginner Joined: 20 Jun 2005 Posts: 29 Topics: 14

hi ,

thank you for your prompt reply

is it possible to get the records, if the part of the key is the 1st field?
how do i do it?

thank you

regrds,
sinduja

kolusu · Posted: Tue Jul 05, 2005 7:34 am Post subject:

sinduja · Beginner Joined: 20 Jun 2005 Posts: 29 Topics: 14

THANK YOU