First, if you have a backup copy of the file, you might need to restore from it. To recover deletions of rows using a journal, you have two possible methods that depend on how the journalling was done. If you started journalling as IMAGES( *BOTH ), then you can use RMVJRNCHG to run the deletions backwards to the time before the deletions started. This is a fairly easy and simple operation. For the most part, you only need to verify that you have the proper receivers available, that you specify the proper receiver (or receivers) and that you specify the correct start and end times. But if you started journalling only with IMAGES( *AFTER ), then you must restore the file from before the deletions and use APYJRNCHG from the point in time of the save up to the point just before the deletions began. An *AFTER image of a deletion contains no data. Therefore, the deleted row cannot be recovered from it. To restore deletions, you need *BOTH in order to have the "before deletion" row data available. Tom That last paragraph sounds scary. The answer, in Tom's earlier paragraphs is YES YOU CAN and there are two ways to recover if you have before and after images but only one way to recover if you only have the after image Phil

First, if you have a backup copy of the file, you might need to restore from it. To recover deletions of rows using a journal, you have two possible methods that depend on how the journalling was done. If you started journalling as IMAGES( *BOTH ), then you can use RMVJRNCHG to run the deletions backwards to the time before the deletions started. This is a fairly easy and simple operation. For the most part, you only need to verify that you have the proper receivers available, that you specify the proper receiver (or receivers) and that you specify the correct start and end times. But if you started journalling only with IMAGES( *AFTER ), then you must restore the file from before the deletions and use APYJRNCHG from the point in time of the save up to the point just before the deletions began. An *AFTER image of a deletion contains no data. Therefore, the deleted row cannot be recovered from it. To restore deletions, you need *BOTH in order to have the "before deletion" row data available. Tom That last paragraph sounds scary. The answer, in Tom's earlier paragraphs is YES YOU CAN and there are two ways to recover if you have before and after images but only one way to recover if you only have the after image Phil