View previous topic :: View next topic
|
Author |
Message |
shahul hameed abdul kader Currently Banned New User
Joined: 20 Feb 2008 Posts: 5 Location: navalur
|
|
|
|
I have one sequential file with records like bank id and I want to search randomly with the records in VSAM file. So I declared in the file section access mode is random so how can I search the particular record in the VSAM file? |
|
Back to top |
|
|
r.ravikumar
New User
Joined: 05 Jan 2007 Posts: 18 Location: chennai
|
|
|
|
HI shahul,
You can pass the value from sequential file to 'Record Key' of VSAM file to access the record in random |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Even though access is random, it is always good practice to sort the control file by the VSAM key before getting the records as you may eliminate a number of I/O operations by reusing the index CI's in memory rather than skipping around the KSDS totaslly randonly, and at some stage in the future reloading the same CI into memory.
In one case many years ago, this took over 30 minutes off of the elapsed time of one job.
Also may be an idea to increase the number of index buffers allocated to your KSDS file, say 10. |
|
Back to top |
|
|
shahul hameed abdul kader Currently Banned New User
Joined: 20 Feb 2008 Posts: 5 Location: navalur
|
|
|
|
I want to search a particular record from one ps file with set of records in VSAM file in random mode if any match then display the same. moreover I assigned access mode is random.
thanks |
|
Back to top |
|
|
kishorekyn
New User
Joined: 20 Feb 2008 Posts: 5 Location: Chennai
|
|
|
|
Just let me know what kind of a VSAM file it is... Then we could help you out |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello kishorekyn,
Please notice that the person you are replying to has been "banned", so they will probably not be able to post the info you asked for. . . |
|
Back to top |
|
|
kishorekyn
New User
Joined: 20 Feb 2008 Posts: 5 Location: Chennai
|
|
|
|
Thanks Dick.... I din't notice that. Sorry |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome
I'm sure there will be other opportunities
d |
|
Back to top |
|
|
|