IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Skip sequential


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
fawzy47
Currently Banned

New User


Joined: 22 Oct 2005
Posts: 42

PostPosted: Tue Feb 21, 2006 4:22 am
Reply with quote

High,
does any body know what skip sequential processing means
Thank you
Fawzy
Back to top
View user's profile Send private message
kumaresh.M

New User


Joined: 17 Feb 2006
Posts: 64
Location: Bangalore

PostPosted: Tue Feb 21, 2006 10:11 am
Reply with quote

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
View user's profile Send private message
fawzy47
Currently Banned

New User


Joined: 22 Oct 2005
Posts: 42

PostPosted: Tue Feb 21, 2006 10:26 am
Reply with quote

How can you do that
Thank you
Back to top
View user's profile Send private message
small_world

New User


Joined: 22 Jul 2005
Posts: 24
Location: pune

PostPosted: Tue Feb 21, 2006 11:00 am
Reply with quote

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.

icon_wink.gif
Back to top
View user's profile Send private message
small_world

New User


Joined: 22 Jul 2005
Posts: 24
Location: pune

PostPosted: Tue Feb 21, 2006 11:08 am
Reply with quote

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 icon_wink.gif
Back to top
View user's profile Send private message
fawzy47
Currently Banned

New User


Joined: 22 Oct 2005
Posts: 42

PostPosted: Wed Feb 22, 2006 5:43 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts SKIP LOCKED DATA in UPDATE statement DB2 9
No new posts How to browse RECFM=VBS DSORG=PSE seq... JCL & VSAM 7
No new posts how to copy a sequential dataset by u... JCL & VSAM 3
No new posts Comparing two sequential files COBOL Programming 14
No new posts Logic to skip Maximum time-stamp and ... DB2 2
Search our Forums:

Back to Top