DDS

SQL

Library – A library is a system object that serves as a directory to other objects. A library groups related objects. The system-recognized identifier for the object is *LIB. Before you can create a database file, you must create a library to store it in.

Collection/Schema

Physical File – A physical file is a database file that stores application data, containing a description of how data is presented to or received from a program and how data is actually stored in the database. A physical file consists of fixed length records that can have variable length fields. Physical files contain at least one member.

Table

Record – A record is a group of related data within a file.

Row

Field

Column

Logical File – A database file that logically represents one or more physical files, and contains a description of how data is presented to or received from a program. This type of database file contains no data but defines are record formats for one or more physical files. Logical files are different from the physical files they represent in that they let users access data in a sequence.

View/Index

SQL Package – An SQL package containing the access plans for a distributed SQL program.

Package

User Profile – The user profile name identifies the user to the server. This user profile name is also known as the user identifier. It is the name the user enters in the User prompt on the Sign On display.

Authorization Name
or Authorization ID