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.