Glossary

OLD TABLE and FINAL TABLE:

`FINAL TABLE` returns the row *after* modification. - `OLD TABLE` returns the row *before* modification.

Learn More

IBM DB2 — Chapter 9: Data Modification: INSERT, UPDATE, DELETE, MERGE, and Transaction Control

Related Terms

"DB2 for z/OS: Diagnosis Guide and Reference" "db2pd — A Practical Guide" "On Writing Well" by William Zinsser "Optimizing DB2 Queries with IBM Data Studio" "Oracle to DB2 Conversion Guide" "Presenting to Win" by Jerry Weissman "Sargable Predicates and Index Design" "Self-Tuning Memory Manager: Under the Hood"

© 2026 DataField.Dev. All rights reserved. | Free Textbooks | For Instructors | Blog | RSS | Privacy Policy | Sitemap | Library