W

walking a set

A retrieval process in which a program using navigational DML or the DBMS, in response to an SQL request, can access all of the members of a set starting with the owner record occurrence and accessing each member occurrence in the set until the program reaches the owner record again.

wallpapering

The process of bursting and assembling a CA IDMS Schema Mapper data structure diagram and (probably) hanging it on a wall for viewing.

warmstart

A method of automatic database recovery that occurs when CA IDMS/DB recognizes a system failure when it restarts the system. It uses the journal files to rollback all transactions that were active when the system failed. To do this, it identifies the disk journal file active at the time of failure, locates the last journal record written before the system failed, and rolls back and writes ABRT checkpoints for all incomplete transactions.

WCC

See write control character (WCC).

weak entity

An entity in the database that is identified only by its relationship with another entity. Typically a weak entity has a primary key that contains only one foreign key.

weight factor

A number assigned by the user to a DDS port and used by DC/UCF to select the path between two CA IDMS DDS nodes when more than one path is available.

WHERE clause, path-DML

In LRF, the clause in a path-DML command that specifies selection criteria to identify the desired database-record occurrences.

WHERE clause, program request

In LRF, the clause in a logical-record program request that specifies selection criteria to identify the desired logical-record occurrences.

WHERE clause, SQL

In SQL, the clause in an SQL DML statement (for example, SELECT and UPDATE) that specifies selection criteria to identify the desired table rows.

wildcard

A single character that represents one or more characters in a string. An entity name with a wildcard character identifies all the entities whose names match the pattern established by the wildcarded name.

window

In CA IDMS Performance Monitor, the portion of a screen that contains data for a specific statistic or help topic. CA IDMS Performance Monitor windows allow you to control rows and columns of data that exceed the width and depth of the terminal screen.

work record

See dialog work record, map work record.

write control character (WCC)

In a map, the internal character that holds various mapout specifications for the display of that map.