O

object

The logical unit in which CA ICMS maintains information. An object can be formatted as a data table (the equivalent of a CA IDMS/DB data table) or can be stored in a free-form format (to hold such information as text, spreadsheets, and graphs).

object dictionary

In CA IDMS Dictionary Migrator, a dictionary that acts as the destination for entities that are moved during the migration process. Your object dictionary is populated by entities that are copied from your source dictionary(s). Only one object dictionary can be used during each migration. See also source dictionary.

object record

1) A record occurrence that is the target of a database access request. 2) At system generation, the dictionary record representing an entity that participates in a DC/UCF system. Object records associate source records with DC/UCF systems. Only object records are used when a DC/UCF system executes. See also source record.

OBTAIN

The navigational database access function that combines the FIND and GET operations to retrieve a record occurrence.

OBTAIN logical record

The LRF database access function that retrieves a logical-record occurrence.

OBTAIN path group

A collection of paths (predefined in a logical-record subschema) designed to service application programs that request a MODIFY logical-record function.

occurrence, logical-record

See logical-record occurrence.

occurrence, override

A specification in the Security Resource Type Table (SRTT) for an occurrence of a resource that overrides the SRTT specification for the resource type.

occurrence, record

See record occurrence.

OCF

See Online Command Facility (OCF)

OCFX task

An online task that executes OCF-language modules; that is, modules containing Command Facility statements.

offline area status

The status for an area defined to the runtime DMCL in which database transactions executing under the central version can neither retrieve nor update data in the area.

offload

The process of moving the contents of a disk file to tape.

OLM

The online mapping facility of DC/UCF. Note that this term no longer refers to the online map compiler (MAPC and MAPB).

OLP

The system task that invokes the online PLOG. See also online PLOG.

OLQ access mode

In CA OLQ, an access mode that you use to access non-SQL defined (that is, ASF) tables and records. See also IDMS access mode.

ON clause commands, path-DML

In LRF, commands that specify path branching, path iteration, or return control to the program in response to a specific error-status value returned by the DBMS.

ON clause, program request

A clause that can be coded in an application program, following a logical-record request, to test for a specific path status returned by LRF.

one-of-a-kind record

See OOAK record.

Online Command Facility (OCF)

The CA IDMS tool you use to submit Command Facility statements interactively and see the resulting output on a display screen. See also Command Facility.

online debugger

A facility to detect, trace, and eliminate errors in programs running under the control of a DC/UCF system.

online mapping (MAPC and MAPB)

The online version of the facility for defining and generating maps for online use (MAPC) or batch (MAPB).

online PLOG

The online version of the PRINT LOG utility that displays the current contents of the DDLDCLOG area of the data dictionary. See also PRINT LOG utility statement

online program

A program that executes in a DC/UCF system. See also batch program, TP-monitor program.

online task

A task defined to the DC/UCF system either during system generation by means of the TASK statement, or at runtime by means of the DCMT VARY DYNAMIC TASK command.

online terminal block (OTB)

In CA ADS, the control block used by the runtime system. Associated with a logical terminal, this block exists across tasks, anchoring all other control blocks. The OTB contains the name of the current dialog and the addresses of the current variable dialog block (VDB) and the fixed dialog block (FDB).

online terminal block extension (OTBX)

In CA ADS, an extension of the online terminal block (OTB) that is created when the runtime system executes an application generated by the application compiler. The OTBX contains pointers to the task application table (TAT) and to the record buffer block (RBB) and application definition block (ADB) for the currently executing application.

online work area (OWA)

In CA ADS, the work area that exists for the life of a task. The OWA contains fields for communication between ADSORUN2 and ADSOCDRV, the subschema control block, a pointer to the current map request block (MRB), and an internal stack.

OOAK record

A one-of-a-kind record type in the database. An OOAK record is created when only one occurrence will exist for a record type.

open cursor

The act of opening a cursor; that is, making the cursor available to the program to fetch cursor rows. See also close cursor.

OPER

The system task code that invokes the DC/UCF dynamic system monitor. See also dynamic system monitor.

operating mode

See protocol.

operative status

In CA ADS, the status of a dialog that is still an active part of an application thread. See also application thread.

OPTF

See RHDCOPTF

OPTI module

See IDMSOPTI module.

optimizer

A component of the SQL option that validates table and column references against the dictionary and selects the most efficient database access strategy for an SQL statement.

OPTIONAL membership

The membership option that determines how member record occurrences are disconnected from the set. When a record has optional membership in a set, occurrences of that record can be disconnected from the set without being erased.

order option

In a non-SQL schema, the specification that indicates the logical order in which member record occurrences are connected within a set occurrence. The following order options are available: FIRST, LAST, NEXT, PRIOR, and SORTED.

orphan count

A count maintained by CA IDMS/DB when adding members to an unsorted indexed set. The orphan count indicates the number of index entries that have been relocated when an SR8 record is split to accommodate new members.

OTB

See online terminal block (OTB).

OTBX

See online terminal block extension (OTBX).

outer join

A SELECT statement operation that joins complete tables; that is, it includes the rows that have no match in another table. The result of an outer join is a result table with all the rows from one of tables in the join operation. See also join.

overflow

In CA IDMS/DB, a condition occurring when records must contend for storage space in the database. The two types of overflow are CALC overflow and clustered (or VIA) overflow. A CALC overflow condition occurs when the randomized page for a CALC record is too full to accommodate the record; the record is stored on the next page. A clustered (VIA) overflow condition occurs if the page size for the database area is too small to hold all occurrences of a clustered relationship.

overflow run unit

A system run unit that is initiated by DC/UCF when all predefined system run units are in use. DC/UCF terminates overflow run units when they are no longer needed.

OWA

See online work area (OWA).

owner linkage

The type of set linkage in which the owner and members of a set are linked by owner pointers. Owner pointers cause each member to point to the owner.

owner record

The record type to which all other records in a set are subordinate.

ownership

1) An attribute of an SQL schema. The user who issues the CREATE SCHEMA statements owns the schema and implicitly holds all access and definitions privileges on the tables, views, and access modules associated with the schema. Ownership can be transferred from one user to another. 2) In CA ICMS, the relationship between a user (or the catalog) and an entity owned by that user. A user can own objects and folders; the catalog can own objects, folders, users, and groups.