Hello Liu, Elke meant: - in the window of SQL Studio called "SQL Dialog" (where you type the SQL commands), at the bottom, there are three drop-down boxes. - you have set the first one to "Auto Commit: on" => each statement is immediately committed as executed => all locks should be gone after commit, so you see nothing
Try again with "Auto Commit: off". Regards Alexander SchrÃder SAP DB, SAP Labs Berlin > -----Original Message----- > From: ç æ [mailto:[EMAIL PROTECTED] > Sent: Monday, April 18, 2005 10:48 AM > To: Zabach, Elke; [email protected] > Subject: RE: AW: explicitly specifying locks and select in > locks table. > > Yes,i used sql studio. > What's the meaning about "committed"?Do you mean the Isolation Level? > I don't find the location of SQLStudio-input-area.Is it in > the maxdb help? > thanks. > > >From: "Zabach, Elke" <[EMAIL PROTECTED]> > >To: "? ?" <[EMAIL PROTECTED]>, <[email protected]> > >Subject: AW: explicitly specifying locks and select in locks table. > >Date: Fri, 15 Apr 2005 10:20:11 +0200 > > > >[EMAIL PROTECTED] wrote: > > > > > > I created a table named "ht_detail". > > > > > > Then i insert three item in the table. > > > > > > After that, i executed a select statement:"select * from > ht_detail > where > > > sbh ='79NK0001' with lock exclusive" > > > > > > After executed that statement, i selected item from the > system table > > > "Locks",but there are no item in it? > > > > > > Why? > > > >This happened perhaps because you used SQLStudio for doing > this and used > 'committed' (see bottom of SQLStudio-input-area), which > means: do a commit > after each command causing locks to be released. > > > >Elke > >SAP Labs Berlin > > > > > > > > _________________________________________________________________ > > > äçäçäæåççåéäççâ MSN Hotmailã > > > http://www.hotmail.com > > > > > > > > > -- > > > MaxDB Discussion Mailing List > > > For list archives: http://lists.mysql.com/maxdb > > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > _________________________________________________________________ > äçäçäæåççåéäççâ MSN Hotmailã > http://www.hotmail.com > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
