Structured query language

The language that you use to access the data in DB2 tables is the structured query language (SQL). SQL is a standardized language for defining and manipulating data in a relational database.

The language consists of SQL statements. SQL is divided into three general categories in which SQL statements let you accomplish the following actions:

  • Define, modify, or drop data objects, such as tables. This category of SQL statements is referred to as DDL (Data Definition Language).

  • Retrieve, insert, update, or delete data in tables. This category of SQL statements is referred to as DML (Data Manipulation Language).

  • Authorize users to access specific resources, such as tables or views. This category of SQL statements is referred ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.