>Jim,
>
>>
>>Let me first ask you to tell me what I should expect to happen when SET TABLEVALIDATE to 2 is in effect and a INSERT INTO... is done to a table that has a header record count that is 1 less than the actual table size and there is NO TRANSACTION processing in effect?
>>
>
>After the append has been saved, if record count in the header and the file size are not in sync then the error should be reported.
>
>I didn't try, but it looks like in your scenario will be no errors and append will NOT be lost.
>
>Thanks,
>Aleksey Tsingauz.