Introduction to DB2 for z/OS
Previous topic | Next topic | Contents | Glossary | Contact z/OS | PDF


SQL: The language of DB2

Introduction to DB2 for z/OS

There are many different types of SQL statements. These statements have different purposes, coding, and occasions for their use.

  • Ways to access data
    You can retrieve data by using the SQL statement SELECT to specify a result table that can be derived from one or more tables.
  • Ways to modify data
    You can use SQL statements to add, modify, merge, and remove data in existing tables. You can use the INSERT, UPDATE, MERGE, TRUNCATE, and DELETE statements to manipulate DB2 data.
  • Ways to execute SQL
    You can execute, or run, SQL statements in applications or interactively. The method of preparing an SQL statement for execution and the persistence of its operational form distinguish static SQL from dynamic SQL.
Parent topic: DB2: The relational database management system for the z/OS environment
Related information

Go to the previous page Go to the next page

Notices | Terms of use | Support | Contact z/OS



Copyright IBM Corporation 1990, 2010