HP3000-L Archives

September 2004, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Venkatraman Ramakrishnan <[log in to unmask]>
Reply To:
Venkatraman Ramakrishnan <[log in to unmask]>
Date:
Fri, 24 Sep 2004 10:08:39 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (40 lines)
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 *

ATOM RSS1 RSS2