View previous topic :: View next topic
|
Author |
Message |
tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
hi,
i have a requirement to get the values from the table related to one record and accomodate in the screen.
suppose screen has only five values to accomodate and the total values are 10 of that paricular record as he presses the PF keys then he has to get the values.
Code: |
*** SCREEN A ***
________
________
________
________
________
PF1 PF2 PF3 .....
|
the Db2 query for this is possible ???? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
the usual approach is to uncouple the database access from the visualization process
run the query an store the results in a TS queue
after that implement the paging from the saved results
( what if after ahving browsed th user wants to print the stuff )
doing it from the sql query makes paging backwards very difficult
( and getting an hardcopy too )
also... an advice, do not reinvent the wheel
CICS and IMS/DC have been alive for quite a long time,
all the decently managed organizations have already developed standards and tools for terminal paging
in order to give all the applications the same look and feel,
and not to have each application developer spending time rewriting what should be a standard approach |
|
Back to top |
|
|
|