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.
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 |