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
 

 

PAGEUP & PAGE DOWN logic in CICS-DB2 PROGRAM(1 rec / pag

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Aham

New User


Joined: 24 Oct 2007
Posts: 42
Location: chennai

PostPosted: Tue May 27, 2008 12:09 pm    Post subject: PAGEUP & PAGE DOWN logic in CICS-DB2 PROGRAM(1 rec / pag
Reply with quote

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Tue May 27, 2008 12:16 pm    Post subject: Reply to: PAGEUP & PAGE DOWN logic in CICS-DB2 PROGRAM(1
Reply with quote

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

New User


Joined: 24 Oct 2007
Posts: 42
Location: chennai

PostPosted: Wed May 28, 2008 10:32 am    Post subject:
Reply with quote

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

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
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


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