how to quickly keep table out of check pending after load and strart from scratch?

Assuming you are on LUW,

Are you looking for something like
SET INTEGRITY
statememt

SQL Reference will have the correct syntax ..

Please read 'Must Read BEfore Posting' thread at the top of the forum

Cheers
Sathyaram

Yes,'set integrity' but we want to bypass integrity check and remove pending status to full acces..
thanks!

Hi,

Check pending state is probably because of foreign keys. If you would like to load data without doing the "set integrity" command at the end to move the table from check pending state to normal state, there is one more option:

1. Drop foreign keys,
2. Load tables
3. create foreign keys.

But be carful - droping foreign keys can be dangerous - because you don't have the referencial integrity.

you can use the non-recoverable option on the load command, it will leave the table in a useable state, but it assumes all your data is good. Make sure you have a good data.

There are 2 ways that I know of (the first is more destructive):

1. Drop the tablespace will remove the flag.
2. START ACCESS(FORCE)