View previous topic :: View next topic
|
Author |
Message |
fawzy47 Currently Banned New User
Joined: 22 Oct 2005 Posts: 42
|
|
|
|
High,
does any body know what skip sequential processing means
Thank you
Fawzy |
|
Back to top |
|
|
kumaresh.M
New User
Joined: 17 Feb 2006 Posts: 64 Location: Bangalore
|
|
|
|
I think that its like dynamic searching,
first it will search in seqencial manner and than it perform randomlly,
for example if we have 20 lines coding,
first we have to search any data seq,
then its getting late we use that skip seq process and do random search
corrections welcome
with regards.
kumaresh.M |
|
Back to top |
|
|
fawzy47 Currently Banned New User
Joined: 22 Oct 2005 Posts: 42
|
|
|
|
How can you do that
Thank you |
|
Back to top |
|
|
small_world
New User
Joined: 22 Jul 2005 Posts: 24 Location: pune
|
|
|
|
A COMBINATION OF BOTH DIRECT AND SEQUENTIAL ACCESS CAN BE USED IN A TWO STEP PROCESS CALLED SKIP SEQUENTIAL.USE KEYED DIRECT ACCESS TO FIND A STARTING POINT.ONCE THE INITIAL RECORD IS OBTAINED ADDITIONAL RECORDS ARE RETRIEVED SEQUENTIALLY.SKIP SEQUENTIAL PROCESSING CAN BE USED WITH A ksds,rrds AND IF IT HAS ASN ALTERNATE INDEX AN ESDS.SKIP SEQ IS USEFUL WHEN PERFORMANCE IS IMPORTANT.THIS IS BECAUSE A SIMPLE SEQ IS FASTER THAN DIRECT RETRIEVAL.YOU KNOW THE KEY RBA OR RRN OF THE FIRST RECORD BUT NOT KNOW THE KEY RBA OR RRN OF THE SUBSEQUENT RECORD.YOU WANT TO PROCESS THE DATASET SEQENTIALLY STARTING AT A RECORD OTHER THAN THE FIRST.
|
|
Back to top |
|
|
small_world
New User
Joined: 22 Jul 2005 Posts: 24 Location: pune
|
|
|
|
For quick direct access to records, you can browse using skip-sequential processing. This reduces index search time. It is useful if the records are retrieved in ascending or descending order, relatively close to each other, but not necessarily |
|
Back to top |
|
|
fawzy47 Currently Banned New User
Joined: 22 Oct 2005 Posts: 42
|
|
|
|
I think the answer is wrong, Skip sequential processing means you start processing the file sequentialy, let say from record 5 to 10, then you need to skip that sequential to other part of the file say from record 19 to 25 sequentaily also.
and for that you need to RESEBR THEN start another browse
Thanks for all of you who tried to help me regardless of those who answer incorrectly
Fawzy |
|
Back to top |
|
|
|