Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 query for scrolling logic on screen

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
tecnokrat
Warnings : 1

Active User


Joined: 22 May 2009
Posts: 160
Location: Bangalore

PostPosted: Tue Nov 17, 2009 12:26 pm    Post subject: DB2 query for scrolling logic on screen
Reply with quote

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10277
Location: italy

PostPosted: Tue Nov 17, 2009 12:39 pm    Post subject: Reply to: DB2 query for scrolling logic on screen
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us