Interfaces to Db2 for i

Db2® for i provides several independent interfaces to the database.

Traditional system interface
The IBM i traditional system interface is the full set of system commands and other non-SQL facilities that you can use to access and change Db2 for i data.
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.
System i Navigator
System i® Navigator is a no-charge feature of the IBM i Access for Windows licensed program. It provides a graphical, Microsoft Windows interface to common IBM i management functions, including database.
IBM Query for i
The IBM Query for i licensed program can be used to select, format, and analyze information from database files to produce reports and other files.

Parent topic: Database file concepts