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^® UDB for iSeries™ database has SQL processing capability integrated into the system. It processes compiled programs that contain SQL statements. To develop SQL applications, you need IBM^® DB2 Query Manager and SQL Development Kit for iSeries (5722-ST1) for the system on which you develop your applications.

Interactive SQL is a function of the DB2 Query Manager and SQL Development Kit for iSeries 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.

 

Parent topic:

Interfaces to DB2 Universal Database for iSeries

 

Related concepts

SQL programming
Introduction to DB2 UDB for iSeries Structure Query Language