Further to this, you could also use the !GET.PATHNAME subroutine to get
the path and filename. A quick way to check rather than the expense of a
DB level OPEN.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder
Sent: Thursday, 5 January 2006 1:42 PM
To: [email protected]
Subject: RE: [U2] openseq question
Allen E. Elwood wrote on 01/04/2006 01:29:47 PM:
> I've always found it helpful to open the file/record in 'regular' mode
first
> to find out if the directory entry worked or possibly to write a null
record
> if it didn't.
So, if the O/S-level file is multi-megabytes, you're reading the whole
thing into memory? That could cause problems with shared memory and
will
certainly create a burden on the system. It also kind of defeats the
purpose of using a sequential file, since you're reading the whole thing
in, then opening it again and reading through the entire file a second
time with READSEQ. Since you've incurred the memory and performance hit
to pull the whole thing into a variable, you might as well waltz through
that variable to extract the lines an attribute at a time with REMOVE or
READNEXT.
If you're following this practice only on small files, and only
infrequently, it's probably OK, but how can you guarantee that will
always
be the case?
Tim Snyder
Consulting I/T Specialist , U2 Professional Services
North American Lab Services
DB2 Information Management, IBM Software Group
717-545-6403
[EMAIL PROTECTED]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
