Subject: | |
From: | |
Reply To: | |
Date: | Fri, 24 Sep 2004 10:08:39 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hello Everybody,
We are writing HP Cobol programs to access Turbo IMAGE databases in MPE
We want to retrieve the records in the sequence in which they were
inserted into the dataset. We have thought of the below three options
Option 1: Serial read using DBGET Mode 2
a) Serial read the dataset using DBGET Mode 2
b) Process each record
Question:
1. Will be the sequence in this case be maintained?
2. Will there be performance issues when the dataset size is going to be
huge as DBGET Mode 2 needs to pass through each record
Option 2: Chain read using DBGET Mode 5
a) Chain read using a dummy field created which will select all the
records in the dataset
b) Sort the table using a Sequence based on the above dummy field
c) Process each record
Option 3: Message file (Option not preferred)
a) Insert records into message file
b) Read from message file and process the record
Pls. let us know your thoughts on the feasibility of first two options
and which would be preferable and why. We have decided not to use
message files for the same.
Warm Regards
Venkat
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|