Introduction to Db2 for i Structured Query Language

Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database. These topics describe the IBM® i implementation of the SQL using the Db2® for i database and the IBM DB2® Query Manager and SQL Development Kit for i licensed program.

SQL manages information based on the relational model of data. SQL statements can be embedded in high-level languages, dynamically prepared and run, or run interactively. For information about embedded SQL, see Embedded SQL programming.

SQL consists of statements and clauses that describe what you want to do with the data in a database and under what conditions you want to do it.

SQL can access data in a remote relational database, using the IBM Distributed Relational Database Architecture™ (DRDA).