Hi,
I am faced with a problem of searching a record in various KSDS files of same format. Can someone throw some light as to how can i search for a record in different VSAM files of same format by writing a JCL?
in which only the cc thing is variable. eg( US, IN, PK ...) and rest is same.
Format of all the files is same. I want to find out a particular string "1Z 11" in these particular files (which would be the primary key) and output which files contain this string as the primary key.
Joined: 10 Oct 2005 Posts: 4 Location: bangalore,india
Hi
Wt i think is u can do it in two step
in 1st step :- concatinate all three ksds fine into a singal ksds file
and in step 2 :- simply search ur desired thing.
But ksds file wont accept dupication of key fields so .....
other way is u can use sort utility.....
u can give multipal sortins all ur ksds files and one sortout .use" include condition". to shorten the sort process
plz do let me know if any of them is usefull or u.
Actually i have 33 such files. and each one's size is quite large, so merging them would not be effective way. instead of that i would rather search each file individually.
1) Copy Each Vsam File to a sequential file.
2) Using DFSORT "INCLUDE" parameter specify the condition reqired.
3) Chk the o/p of DFSORT step which will give the result.
Print command of the IDCAMS can also be added to check if the o/p of DFSORT is empty or not
