Hi Guys....Today i just thought of sharing something on SQL400 for beginners...
SQL Relational Database In the relational model of data, all data is perceived as existing in tables. DB2 UDB for AS/400 objects are created and maintained as AS/400 system objects.
AS/400 System Terms and SQL Relational Database terms
System Terms | SQL Terms |
Library. Groups related objects and allows you to find the objects by name. | Collection. Consists of a library, a journal, a journal receiver, an 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. | View. A subset of columns and rows of one or more tables. |
SQL Package. An object type that is used to run SQL statements. | Package. An object type that is used to run SQL statements. |
User Profile | Authorization name or Authorization ID. |
