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