Introduction to DB2 UDB for iSeries Structured Query Language
Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database. These topics describe the System i™ implementation of the SQL using DB2® UDB for iSeries™ and the DB2 Query Manager and SQL Development Kit 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®).
- SQL concepts
DB2 UDB for iSeries SQL consists of several main parts, such as SQL runtime support, precompilers, and interactive SQL.
- SQL objects
SQL objects are schemas, journals, catalogs, tables, aliases, views, indexes, constraints, triggers, sequences, stored procedures, user-defined functions, user-defined types, and SQL packages. SQL creates and maintains these objects as system objects.
- Application program objects
Several objects are created during the precompile of a DB2 UDB for iSeries application program.
Parent topic:
SQL programming
Related concepts
Distributed database programming
Related reference
Distributed relational database function and SQL