|
View previous topic :: View next topic
|
| Author |
Message |
sreelekshmi
New User
Joined: 16 Jan 2007
Posts: 9
Location: Bangalore
|
|
|
|
Hi,
I have one requiremtn like this :
After entering the account number and when enter key is pressed,the screen should display the details of the next 6 account numbers starting from the one I entered.
Also when there is more data in the file,while pressing the PF8 i shpuld be able to browse the next six records.Also when PF7 is pressed I have to get the previous 6 records.
I neeed to implement this using the queue.But I am not able to code the steps in the proper way.Do I need to declared the repeteting map fields in an array and move each value from the queue to the map filed?
Can anyone guide me on this ?
Thanks in advance.
sree |
|
| Back to top |
|
 |
Mickeydusaor
Active User
Joined: 24 May 2006
Posts: 258
Location: Salem, Oregon
|
|
|
|
There are many ways to do this, first what type of file are you
reading to obtain the infromation from, VSAM, DB2 .....?? |
|
| Back to top |
|
|
sreelekshmi
New User
Joined: 16 Jan 2007
Posts: 9
Location: Bangalore
|
|
|
|
i am using the VSAM files....i need to use the queues.....
Thanks
Sree.. |
|
| Back to top |
|
|
Mickeydusaor
Active User
Joined: 24 May 2006
Posts: 258
Location: Salem, Oregon
|
|
|
|
I would not waste my time with queues, I would keep the top
record key and the bottom record keys in the commarea
and just do a startbr, with a readnext or readprev, depending
on weather I was paging forward or backward. |
|
| Back to top |
|
|
TG Murphy
Active User
Joined: 23 Mar 2007
Posts: 148
Location: Ottawa Canada
|
|
|
|
Our shop has a standard that paging screens MUST cache their result set in TS queues to 1) minimize the number of hits on DB2 and 2) avoid the need to define additional DESCENDING indexes. So perhaps you are in the same boat as us, eh? You have no choice but to use TS queues.
Our systems programmer tells me that data in TS queues is actually stored in memory - so access to this data would be extremely fast. And I can vouch that it is.
Here is how it is done here. Let's say your screen contains 10 repeating rows. The data for an entire screen is stored in a single TS queue item. Thus, all the data for page 1 is stored in TS queue item 1. All the data for page 2 is stored in item 2. And so on.
When the user starts working on one of these screens, our business layer will be invoked to retrieve X number of rows - let's say X is 50. The entire result set may contain 300 rows. The screen displays showing the following up near the top: Page 001 of 005 +
The + sign means that there is more data. Only when the user attempts to scroll to page 6 will the presentation layer program invoke the business layer program to obtain pages 6 thru 10.
The screen will now show: Page 006 of 010 +
When the user hits PF7-Scroll Back, the page will be retrieved from the TS queue. And most PF8-Scroll Forward requests will also be satisified from the TS queue.
The + sign will only disappear when the entire result set has been loaded into the TS queue.
The user can overtype the Page number to go directly to a specific page (something I don't think they need to do often). |
|
| Back to top |
|
|
Mickeydusaor
Active User
Joined: 24 May 2006
Posts: 258
Location: Salem, Oregon
|
|
|
|
Now times that plus 1000 users and see if you system will still
be running. There are know other indexs you have to worry
about, as your key to the top and bottom record is your is
your index. |
|
| Back to top |
|
|
|
|
