tsq or read directly from file
Posted: Wed Apr 07, 2010 5:59 pm
Hi for paging logic(page down and page up) using vsam which is better from performance point
a) to read the file every time using readnext(page down) and readprev(page up)
b) to read the file and write all the records which satisfy some condition into tsq and then use tsq for paging logic
a) to read the file every time using readnext(page down) and readprev(page up)
b) to read the file and write all the records which satisfy some condition into tsq and then use tsq for paging logic