SQL

Structured Query Language (SQL) is a standardized language that can be used within host programming languages or interactively to define, access, and manipulate data in a relational database.

SQL uses a relational model of data; that is, it perceives all data as existing in tables. The Db2 for i database has SQL processing capability integrated into the system. It processes compiled programs that contain SQL statements. To develop applications which use Embedded SQL, you need the IBM Db2 Query Manager and SQL Development Kit for i licensed program for the system on which you develop your applications.

Interactive SQL is a function of the IBM Db2 Query Manager and SQL Development Kit for i licensed program that allows SQL statements to run dynamically instead of in batch mode. Every interactive SQL statement is read from the workstation, prepared, and run dynamically.

The Run SQL Statements (RUNSQLSTM) and Run SQL (RUNSQL) commands provide command interfaces for dynamic execution of SQL statement(s) driven by a CL command.