Re: Table in use message

I will try this. It is not so easy, because the file has many users 24 x 7.


CRPence wrote:

On 27-Oct-2011 15:23 , Raul A. Jager W. wrote:

Sorry, I misspelled SQL.

CRPence wrote:

I am not sure what QSL is, but again, eliminating the allocation
which leads to the CPF3202 is the key to resolution.

On 27-Oct-2011 13:22 , Raul A. Jager W. wrote:

I get the same messages if I try to add the constraint from QSL.

Arghh. Seems so obvious now... that SQL ALTER TABLE ADD CONSTRAINT was tried versus ADDPFCST; with same result.

Might be worth trying the SQL request to ALTER TABLE ADD CONSTRAINT with commitment control active for the SQL request. That is a somewhat different code path than ADDPFCST. See if there is some difference or maybe even success with that path, as compared to the failing ADDPFCST request.

Regards, Chuck