View previous topic :: View next topic
|
Author |
Message |
Aham
New User
Joined: 24 Oct 2007 Posts: 42 Location: chennai
|
|
|
|
Hi,
I have a requirement that the DB2 table being queried has the composite primary key(made of 4 fields). User may enter the 2 or 3 of the fields and the program has to get the matching records displaying one record per page. When the user enters PF8 the COBOL program should get the second record and PF7 means previous record ( from the fileds matching entered values only) and so on... I searched in the net but the IBM material seems unavailable for the same. Kindly get me some help |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
paging is a process that should always be decoupled from the data access
two reasons ( mainly )
- software reuse, all the decently managed shops have a generalized paging routine..
( common process used by everybody, no need to rewite and test every time )
data consistency
if for every page tha data base is reaccessed the data might be different
( if You jot down some numbers while browsing You expect them not to change until the end )
the msot common solution is..
access the data base,
write the formatted lines to TS
invoke the standard paging program |
|
Back to top |
|
|
Aham
New User
Joined: 24 Oct 2007 Posts: 42 Location: chennai
|
|
|
|
Thank you for the response. I just cant figure out a proper logic out for standard paging routine. That is my problem |
|
Back to top |
|
|
|