Re: Table in use message

["Raul A. Jager W." <raul@xxxxxxxxxx>]

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
>