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 SQL applications, 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.