Not All Records Being Deleted

[Rohde, Dirk]

We are running a little script to delete some records in an Oracle table
"REC" as follows:

 

Q T P   (PowerHouse  8.43.D1)

Copyright 2005 COGNOS INCORPORATED

Licensed PH8-UNIX-RUNTIME for customer

 

> access REC

> select if REC_CREATE_DATE <= 20080715

> subfile SAVE_REC keep include REC

> output REC delete

> go

 

Executing request 1 ...

 

Records read:

  REC                                  3,473

 

Transactions processed:                  340

 

Records processed:                     Added    Updated  Unchanged
Deleted

  REC                                      0          0          0
61

  SAVE_REC                               340          0          0
0

 

Finished.

> 

 

This is version 8.43.D1 running on HP-UX using an Oracle 10.2 database.
REC_CREATE_DATE is a date (with century included) field. There is a
delete trigger on REC but it is only used to generate some data in
another Oracle table. When we tried to delete just the remaining 279
records using the same code, it still would not delete the records, yet
it selected them for the subfile. Has anyone seen this sort of thing
happen before or have any thoughts as to why it cannot delete some of
the records (without reporting an error)?

 

Dirk Rohde
VantagePoint Systems, Inc.
T: 604-685-4209 x 239 
F: 604-685-4186
  

  <http://www.vpgroup.com> 

 


This email may contain information that is privileged, confidential, or otherwise exempt from disclosure under applicable laws.  Unauthorized use, reproduction or dissemination of this email is strictly prohibited. If you have received this e-mail in error please inform the sender and delete it from your mailbox or any other storage mechanism. VantagePoint Systems, Inc. cannot accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of VantagePoint Systems, Inc. or one of its agents.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080814/3bb9bd92/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 9443 bytes
Desc: image001.gif
Url : http://lists.sowder.com/pipermail/powerh-l/attachments/20080814/3bb9bd92/attachment-0001.gif