|
On 10/23/06, Wilt, Charles <CWilt@xxxxxxxxxxxx> wrote:
Dan, What version are you on? A quick test on my system (v5r4) didn't leave any deleted records in the [file].
IIRC, v5r3 was the same. Which makes make sense given the changes made
in v5r3 to which my first post talks about.
Sorry, I forgot to mention that we are on V5R3. Also, specific to the reference you quoted earlier:
The target table is not a view, it's a plain old physical file. A significant (???-there are only less than 100 records in the file; what
is "significant"???) number of rows are being deleted.
No open cursors on the file No other job has a lock on the table. The table does not have an active delete trigger. The table is not the parent in a referential constraint, period. I am able to run CLRPFM on the file manually, so I presume I have *OBJMGT
or *OBJALTER system authority on the table. Maybe it is new to V5R4? - Dan
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
