Re: SQL REUSEDLT

wrote:

Jorge - I think when you do a CHGPF on a SQL created file it is no longer
treated as SQL created. Not 100% on that, but I thought I came across that
somewhere.

Rob - good questions. I was asking because I wanted to know what my
options are. There is concern in the shop about reusing deleted records.
While I'm not sure of their reasons, there is a performance consideration.
Reusing deleted records results in a "nominal" performance hit, but nominal
adds up when batch processing millions of records (in this case it's
doubtful that there'd be millions of deleted records - although I don't know
if the nominal hit is in regard to hitting the Deleted Record Map before
performing the write or in the reuse of the deleted record itself).

Dennis - thanks for the info.

-Kurt

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, February 11, 2010 2:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL REUSEDLT

Why would you not want it to? Are you relying upon arrival sequence? Can
you bypass that by adding a "sequence" column to the table? If you're
concerned about sequence rollover, log a date along with the sequence.
That should work unless you plan on rolling over your sequence in the same
day.


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 02/11/2010 02:59 PM
Subject: SQL REUSEDLT
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Is there a REUSEDLT(*NO) equivalent in SQL's Create Table? (I didn't have
any luck in finding one on the web.)

We're at v5r4.

Thanks,

Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.