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: 10276
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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm


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