row lock

[jerryzhang83]

which statement can replace the sql of SQL Server " select * from table with (rowlock) where id=10;" in ingres?

[kschendel]

set lockmode on table xxx where level = row;
select * from table where id = 10;

More precisely, there is no direct equivalent. Ingres does not allow specification of the lock-level on the select statement (for perfectly good implementation reasons; I'm mildly surprised SQL Server allows it). You define the lock level (table, page, row, in 10.0 mvcc) at the transaction level to Ingres and the DML in the transaction obeys that directive.