If your system runs in ANSI mode it should be quite similar to DB2. Check the manuals, especially the ANSI session stuff in:
SQL Reference, Statement and Transaction Processin
Chapter 7: Locking and Transaction Processing
If your system runs in Teradata mode, then it's totally different...
Dieter