DB2 graphic  QMF Version 8

iSeries terminology

QMF for Windows uses SQL terminology. The following table lists iSeries system terms and corresponding SQL relational database terms. For more information, refer to DB2 UDB for iSeries Database Programming.

Table 2. iSeries and SQL terminology
iSeries Term SQL Term
Library: Groups related objects and allows you to find objects by name. Collection: Consists of a library, journal, journal receiver, SQL catalog, and, optionally, a data dictionary. A collection groups related objects and allows you to find the objects by name.
Physical file: A set of records. Table: A set of columns and rows.
Record: A set of fields. Row: The horizontal part of a table containing a serial set of columns.
Field: One or more characters of related information of one data type. Column: The vertical part of a table of one data type.
Logical file: A subset of fields and records of one or more physical files. Package: An object type that is used to run SQL statements.
User profile Authorization name or authorization ID


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004