Re: problem changing lock mode to a table

Hi, Try: lock mode(ROW) No space between the mode and the bracket. Rick Obnoxio The Clown wrote: > rachisa said: > >>Hi, >> >>I have a problem with IDS 10.0 running on HP-UX 11.23, I'm trying to >>change the lock mode, i've seen the sintaxis about the alter command >>to change lock mode to tables it seems to be ok, but when i execute >>since dbaccess, it sends a sintaxis error, >> >>I'm using this sentence, >> > > > Alter Table tab1 lock mode (row);> > RTCM. > > >>it sends me an error like this >> >>A syntax error has occurred. error -201 >> >>If anyone can help me, thnx >> >>_______________________________________________ >>Informix-list mailing list >>Informix-list@iiug.org >>http://www.iiug.org/mailman/listinfo/informix-list >> > > >

we normally use; select "alter table ",tabname,"modify lock mode (row);" from systables where some-where clause and locklevel = "P"; then cut and paste the result HTH