the continuing story of the locks :)

Hi ! I'm still working on locks with my applications .... Just another question to the guru's of the sysmaster database. Is there a way to know on wich row on a table thereis a lock ? and how to find out if it's a lock for an insert or for an update. The Ids certainly know if a row is locked for an update or for an insert ? (i think IDS but must know ....) So can we get the informations from somwhere ?? syslocks seems to have the informations (with type) but the way it works still seems "strange" to me . ... SO as IDS must have these informations somewhere .... is there a way to obtain these ???? thx by advance :)

none a 'crit : > Hi ! > > I'm still working on locks with my applications .... > > Just another question to the guru's of the sysmaster database. > > > Is there a way to know on wich row on a table thereis a lock ? > and how to find out if it's a lock for an insert or for an update. > > > The Ids certainly know if a row is locked for an update or for an insert > ? (i think IDS but must know ....) > > > So can we get the informations from somwhere ?? > syslocks seems to have the informations (with type) but the way it works > still seems "strange" to me . ... > > SO as IDS must have these informations somewhere .... is there a way to > obtain these ???? > > > thx by advance :) i ommit all the basics .... sorry for that AIX - IDS 9.4 in ANSI (but will use what will be needed :=)) Committed read , not wait And just a little precision .... I would have theses informations by using query ... not informix uitlities ..