× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.





If you declare the file without index, the chain will be by RRN.

El 28-05-2020 17:46, Robert Wenzel escribió:

I have DDS Physical files that are multi-member files and are
declared REUSEDLT(*YES). Is there a keyword or phrase that will force the
next insert to the next RRN without reusing an empty/deleted record?

Why I ask ; I need to have an SQL Insert statement to insert the next
record to the end of the file (not a reused RRN). The files do not have
unique keys. I cannot modify them. I have an application that will allow
a user to delete and then, potentially, recover the deleted records. I
catalogue the RRN of the deleted record in an audit file with the original
RRN (from the original member) and the new RRN (of the recovery member).
After recovery I catalogue the RRN of the record that was inserted into the
original member from the recovery member. The problem occurs if the
user deletes, for example, RRN #1 then deletes RRN #2 and then recovers RRN
#2. DB2 places the "new" (recovered) record in the RRN #1 location of the
PF. My catalogue now has duplicate RRNs of records that were deleted from
RRN position 1. This should not be the case.

I know I can change the attributes of the PF, even temporarily, but many
batch jobs use these files throughout the day. I would prefer an SQL
statement directive.

Thank you all.

--

*Robert Wenzel, Software Engineer*
iSeries Applications Support and Development

[image: Inmar]
<https://www.inmar.com/?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=Inmar%20Logo [1]>

robert.wenzel@xxxxxxxxx

635 Vine Street, Winston Salem, NC 27101
*p: 336-770-3478*
www.inmar.com [2]
<https://www.inmar.com/?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=URL%20link [3]>
| LinkedIn <https://www.linkedin.com/company/inmar [4]> | Facebook
<https://www.facebook.com/inmarinc [5]> | Twitter
<https://twitter.com/inmarinc [6]>

--

********************************************

*Inmar Confidentiality
Note*: This e-mail and any attachments are confidential and intended to be
viewed and used solely by the intended recipient. If you are not the
intended recipient, be aware that any disclosure, dissemination,
distribution, copying or use of this e-mail or any attachment is
prohibited. If you received this e-mail in error, please notify us
immediately by returning it to the sender and delete this copy and all
attachments from your system and destroy any printed copies. Thank you for
your cooperation.

*Notice of Protected Rights*: The removal of any
copyright, trademark, or proprietary legend contained in this e-mail or any
attachment is prohibited without the express, written permission of Inmar,
Inc. Furthermore, the intended recipient must maintain all copyright
notices, trademarks, and proprietary legends within this e-mail and any
attachments in their original form and location if the e-mail or any
attachments are reproduced, printed or distributed.

********************************************



Links:
------
[1]
https://www.inmar.com/?utm_source=email%20signature&amp;utm_medium=email&amp;utm_campaign=Associate%20Email%20Signature&amp;utm_content=Inmar%20Logo
[2] http://www.inmar.com
[3]
https://www.inmar.com/?utm_source=email%20signature&amp;utm_medium=email&amp;utm_campaign=Associate%20Email%20Signature&amp;utm_content=URL%20link
[4] https://www.linkedin.com/company/inmar
[5] https://www.facebook.com/inmarinc
[6] https://twitter.com/inmarinc

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.