Previous Topic: TNext Topic: V


U

UCF system

A database/data communications system that includes CA IDMS/DB and CA IDMS UCF. A CA IDMS UCF system does not include CA IDMS/DC.

UDAS

The CA IDMS UCF Distributed Application Support Feature. With this feature, an application may be distributed between the front-end system and the back-end system in an environment that consists of one of two CA IDMS/DC systems or a CA IDMS/DC back end and a front end on a system using one of the TP-monitors supported by CA IDMS/DC.

UDP

See user datagram protocol.

unique constraint

A constraint that requires each row of a table be unique with respect to the value of a column or combination of columns. A unique constraint is defined when an index or CALC key is defined with the UNIQUE parameter. See also referential constraint.

unique key

In logical database design, an attribute or combination of attributes whose value(s) uniquely identifies an occurrence of an entity or relationship.

unit of recovery (UR)

A set of changes that is committed or backed out as a single unit.

universal time, coordinated (UTC)

The international time standard. All time zones are defined as offsets from the central UTC time.

unlinked constraint

A referential constraint for which CA IDMS/DB does not maintain a physical linkage between the rows in the referenced and referencing tables. Instead, the referencing table must have a CALC key or index key and the order of the columns in the primary key must match the order of columns of the foreign key. If using an index on the foreign key, additional columns may be defined after the foreign key columns.

unlinked index

A system-owned index in which there are no index pointers in the member records.

unlinked relationship

A relationship in which no embedded pointers are used to link related entity occurrences. See also linked relationship.

UNLOAD utility statement

The utility that unloads records from one or more areas of the database in preparation for reloading.

unload/reload

The process of unloading and reloading a database or portion of a database. The unload/reload process is performed with the CA IDMS/DB utility statement UNLOAD and RELOAD, and is sometimes required when restructuring a database.

UNLOCK utility statement

The utility that removes the external lock on an area.

unsorted set

A set in which the member records are not maintained in sequence by a symbolic key value.

unstructured object

See free-form object.

updatable cursor

A cursor that allows the program to update or delete the row on which the cursor is positioned. See also cursor, global cursor, shared cursor, external cursor.

updatable view

A view derived from a single table or view through which you can update, insert, and delete rows.

update area status

The status of an area in which a database session executing under the central version can retrieve and update data within the area; local mode applications and other central versions can retrieve from, but not update, the area.

update path

The logical-record path (defined in a subschema) that carries out the ERASE, MODIFY, or STORE logical-record function requested by an application program.

update ready mode

An area ready mode in which the readying transaction can both update and retrieve data within the area.

UPDATE statement

An SQL database access statement that modifies the values in one or more rows of a table.

UPDATE STATISTICS utility statement

For an SQL-defined database, the utility that updates statistical information maintained in the dictionary for one or more tables.

update-intent-exclusive lock

A logical lock placed on an area that allows exclusive locks to be placed on records within the area by the issuing transaction, but not by other transactions. See also intent lock, intent-share lock, intent-exclusive lock.

upload

The transfer of data from a personal computer or minicomputer to CA ICMS.

UR

See unit of recovery.

USA date/time format

A date/time format that complies with the IBM USA standard: DATE as mm/dd/yyyy and TIME as hh:mm AM and hh:mm PM.

user

Under centralized security, an entity created with the CREATE USER statement that defines a user in the user catalog.

user catalog

Under centralized security, the repository that contains the definition of all authorization IDs within the CA IDMS security domain, definitions of user profiles, and privileges held by users and groups on global resources. See also global resource.

user datagram protocol (UDP)

An unreliable, connectionless IP protocol.

user exit

A predefined entry point in a DC/UCF system. User exits let you receive control at specific times during system execution. You can use these exits to implement various types of site-specific processing, including statistics collection and security checks.

user function

See DCUF command.

user mode

The execution mode in which a program can access only storage pages that it owns.

user profile

A profile that includes attributes for a user session on any DC/UCF system in the security domain. For example, system-independent information such as the user's employee number. See also system profile.

user program function

See program function.

user response

In CA ADS, the combination of a control key and response field value (if any) that a runtime user enters on mapin. In an application, the user response must be a valid application response.

user storage

Storage in a DC/UCF storage pool that, once allocated, is available for use by the requesting task. See also kept storage, shared storage.

user trace facility

The DC/UCF debugging tool that saves information related to programs executing from a logical terminal. The user trace facility is controlled by the DCUF SET USERTRACE command. The facility captures the program name, request type, and system registers for each program executed from a logical terminal.

user-defined edit module

In the DC/UCF mapping facility, an Assembler program that can be coded to supplement or replace automatic editing and error handling on mapin and/or mapout. See also automatic editing, error handling.

user-defined entity

An IDD entity type used to document information that does not conform to any of the standard entity types.

user-defined nest

A relationship between occurrences of a single entity type expressed in terms that are meaningful to IDD users.

user-owned indexed set

An indexed set in which the owner of the set is a user-defined record. See also system-owned indexed set.

user-written edit module

See user-defined edit module.

UTC

See universal time, coordinated (UTC)