problem changing lock mode to a table

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; it sends me an error like this A syntax error has occurred. error -201 If anyone can help me, thnx

Try. Alter Table tab1 lock mode (row); -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of rachisa Sent: Tuesday, May 16, 2006 3:03 PM To: informix-list@iiug.org Subject: problem changing lock mode to a table 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; 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

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 > -- Bye now, Obnoxio Information within this post contains forward looking statements within the meaning of Section 27A of the Securities Act of 1933 and Section 21B of the S E C Act of 1934. Statements that involve discussions with respect to projections of future events are not statements of historical fact and may be forward looking statements. Don't rely on them to make a decision. The poster is not a reporting company registered under the Exchange Act of 1934. I have received a life peerage from Her Majesty, who is not an officer, minister or affiliate Labour party member. I intend to recover my loan now, which could cause the parliamentary majority to go down, resulting in losses for you. Today's Labour party has: an accumulated deficit and a reliance on loans from officers and affiliates to pay expenses. It is not an operating political party. The party is going to need financing to continue as a going concern. A failure to finance could cause the party to go out of business. This report shall not be construed as any kind of investment advice or solicitation. You can lose all your money by investing in this party.