iSeries terminology
QMF for Workstation and QMF for WebSphere® use SQL terminology, which, in some cases, is different than iSeries terminology.
The following table lists iSeries system terms and corresponding SQL
relational database terms. For more information, refer to DB2® for iSeries Database Programming.
| 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 |