This chapter provides a sample ESL program that shows how to use the following types of SQL statements to cycle through data in a database table:

•Multi-row SELECT statement with a FOR UPDATE OF clause

•Positioned UPDATE statement

•Positioned DELETE statement

In this program, we use the SAMPLE database supplied with DB2.