Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Page up and Page down logic in Cobol-CICS

Page up and Page down logic in Cobol-CICS

Page up and Page down logic in Cobol-CICS

How should I take of page up and page down logic when coding cobol-cics program.

RE: Page up and Page down logic in Cobol-CICS

The use of the TSQ as above is quite a tried and tested method. However there are other options, which may or may not be more efficient depending on the nature of your transactions.

Also be wary of TSQ's in the future as many shops are moving to TORs and AORs. Depending on the specific implementation there may be no gaurantee any longer that you will be able to pick up a TSQ, so created in such a shop, on subsequent transactions.

It is possible just to read the first 8 records, store the key in the COMMAREA, CICS MAP, wherever. Then use the key to start reading from the next set of data. This has the advantage that you are only reading the records your user requests rather than all records. However it is possible to combine read ahead logic and tsq processing together to ensure you only read from a file once per record. It's down to how you design it basically, are the users going to scroll backwards very often or not?

If your using later versions of DB2 you may want to include scrollable cursors to help with positioning. Regardless of which version your using it is possible to write SQL in such a manner that it is effectively positionable within a table, so you can always "start from where you left off", as long as you store and return a key to your application. I can give you some SQL examples of this if you wish.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close