S

scalar function

In SQL programming, a function that returns a single value. This value is derived from the expression or expressions in the arguments of the function invocation. For example, the scalar function DATE obtains the date from a specified value expression.

schema

The part of the database definition that describes the logical structure of the database, including the names and descriptions of all tables, elements, records, sets, and areas. One schema exists per database.

schema compiler

A CA IDMS/DB-supplied program that converts source non-SQL schema DDL statements into description of a database and stores this description in the data dictionary.

schema Data Description Language

The DDL that defines a non-SQL schema.

schema DDL

See schema Data Description Language.

schema-owned record

A database record defined through the schema compiler or copied into the schema.

scratch area

See DDLDCSCR area, DDLOCSCR area.

scratch record

A record stored in the DDLDCSCR or DDLOCSCR area. Scratch records, once stored, are available to any task running on the same logical terminal. Scratch records are maintained until system termination.

screen

See panel.

SDEL task

In CA IDMS centralized security, a DC/UCF system task that deletes all privileges associated with logically-deleted authorization identifiers.

search condition

A boolean expression that yields a truth value. The operands of a search condition are predicates, and the operators are the logical operators AND, OR, and NOT.

searched delete

Using SQL DML, removing rows in a table by deleting each row in the table that meets the search criteria specified in the WHERE clause of the DELETE statement. See also positioned delete.

searched update

Using SQL DML, modifying data in a table for any row that meets the search criteria specified in the WHERE clause of the UPDATE statement.

secondary key

An attribute in a data entity that is used by certain business functions to access occurrences of that entity. For example, an EMP-NAME might be the secondary key and EMP-ID might be the primary key for the entity EMPLOYEE. See also primary key, foreign key.

secondary storage pool

A DC/UCF storage pool other than pool 0 or 255. Secondary storage pools are numbered from 1 through 254. DC/UCF uses secondary storage pools for user-type storage (rather than system storage). Secondary storage pools are optional.

security domain

Under centralized security, the set of DC/UCF systems and local mode jobs that share a set of user definitions.

segment

A grouping of areas and files that contain the data in the database. A segment represents a physical database usually defined by a single schema. For CA IDMS/DB to access a segment at runtime, it must be included in the definition of a DMCL.

select

The generic relational operation through which only specific rows of a data table are accessed.

SELECT clause

In LRF, the section in a PATH-GROUP clause that delimits a path and, optionally, contains path selectors.

SELECT statement

An SQL database access statement that retrieves values from one or more tables and views and returns the values in the form of a result table.

selection criteria

An expression that specifies which rows of a data table are to be selected for processing. Selection criteria can include both arithmetic and logical operations.

selectors, path

See path selectors.

self-referencing relationship

A relationship between different occurrences of the same entity. A bill-of-materials is an example of a self-referencing relationship. See also bill-of-materials structure.

server node

In a DC/UCF communications network, the DC/UCF system that actually services the database request initiated by the host node. See also host node, target node.

service driver

A continuously active task that provides system services. See log service driver.

session default dictionary

The dictionary that will be accessed within a user session if none other is explicitly identified. The session default dictionary can be established through profile attributes, DCUF statements, SYSIDMS parameters, or the system default dictionary.

set

1) A synonym for set type. 2) A group of record blocks that represent a CA IDMS set and are connected to one another with set connection lines in the CA IDMS Schema Mapper data structure diagram. Each set is numbered in the diagram with a unique set number. Sets are also listed, with their descriptions, in the Cross-Reference Report.

set connection

A physical line or series of lines, each with an arrow at the end that points toward a member of a set in the CA IDMS Schema Mapper data structure diagram. Set connections connect an owner of a set and its members.

set junction character

Under the CA IDMS Schema Mapper, an uppercase letter O used at a junction where a multi-member set connection line splits into more than one line.

set membership options

See membership options.

set number

A unique number assigned by CA IDMS Schema Mapper to identify each set and index in a schema or subschema. Set numbers appear in the CA IDMS Schema Mapper data structure diagram as part of set connection lines and index lines. For multi-member sets, the set number appears in the diagram next to the owner and each member. Set numbers are cross-referenced in the Cross-Reference Report.

set occurrence

An owner record occurrence and all of its member record occurrences.

SET OPTIONS

The statement or function that defines default processing options for the current session of the command facility or a CA IDMS compiler.

set order options

See order option.

set type

A structure representing a relationship between two or more record types, where one record type is the owner and the others are members.

setup phase

The preliminary part of the debugging process when, typically, programs are identified to the debugger.

sharable transaction

A transaction initiated by a database session for which transaction sharing is enabled. A sharable transaction can be shared by other sessions that are peers of the initiating session and by sessions that are subordinate to the initiating session. See also non-sharable transaction, peer session, subordinate session.

share lock mode

A logical lock mode placed on areas and records that guarantees that no updates are made to data while a transaction is accessing it. A share lock placed on an area implies a share lock on each record within the area. See also exclusive lock mode, null-lock mode.

shared cache

The Shared Cache feature allows multiple CA IDMS central versions to share database buffers for one or more files through the use of the IBM Parallel Sysplex Coupling Facility.

shared cursor

A cursor that is declared and opened in one program and accessed in another program, where both programs are included in the same access module. See also cursor, updatable cursor, global cursor, external cursor.

shared retrieval ready mode

A retrieval ready mode in which other transactions executing concurrently under the central version can ready the area in shared update, shared retrieval, protected retrieval, or protected update modes.

shared storage

Storage in a DC/UCF storage pool that, once allocated, is available to all tasks in the DC/UCF system. See also kept storage, user storage.

shared update ready mode

An update area ready mode in which other transactions executing concurrently under the central version can ready the area in shared update or shared retrieval ready modes.

shiftin character

A hardware-dependent character that indicates the beginning of a double-byte character set string. A shiftin character can occupy from 1 to 3 bytes.

shiftout character

A hardware-dependent character that indicates the end of a double-byte character set string. A shiftout character can occupy from 1 to 3 bytes.

shutdown

The process of stopping DC/UCF system execution.

signoff function

In CA ADS, a system function used in conjunction with signon security. When selected at runtime, the SIGNOFF function signs the user off the application, then redisplays the screen from which the function was selected.

signon function

In CA ADS, a system function that validates a user's id and password when the user invokes an application.

signon processing

Under centralized security, processing that identifies and validates the user requesting CA IDMS services. It also processes user-related information such as the list of groups to which a user belongs and profile information.

signon profile

1) A command list (CLIST) module associated with a particular user (through a system or user profile attribute) and executed automatically when that user signs on to DC/UCF. 2) In CA OLQ, a series of CA OLQ commands saved as a qfile that is executed automatically when a user signs on to CA OLQ. A signon profile can be associated with a particular user to tailor the user's CA OLQ session.

SKIP Mode

An Animation Mode that you specify during an Animation Runtime Session in Interruptable Mode. CA ADS Alive responds by changing the Animation Mode to STEP Mode and a specified number of statements are bypassed before dialog animation is stopped again. See also STEP Mode.

SME

See space management entry (SME).

SMI

See space management interval (SMI).

SMP

See space management page (SMP).

socket

The end point of an IP communication.

socket descriptor

A value that uniquely identifies a socket. The socket API runtime assigns the socket descriptor.

sockets

An API used by two application programs to communicate with each other. It is most commonly used in conjunction with TCP/IP.

sorted set

In CA IDMS/DB, a set in which the member record occurrences can be retrieved in order by database key, symbolic key, or generic key.

source dictionary

In CA IDMS Dictionary Migrator, the dictionary which acts as a reservoir for entities that are available for migration into another (object) dictionary. Your source dictionary is not changed during the migration process. Multiple source dictionaries can be used during each migration. You can also use your object dictionary as a source dictionary. See also object dictionary.

source record

At DC/UCF system generation, the data dictionary record that represents an independent entity. See also object record.

space available count

The number of bytes of free space on a database page.

space management entry (SME)

In CA IDMS/DB, a 2-byte item on the space management page of an area in the database. There is a one-to-one correspondence between the number of space management entries and the number of pages in the area. The SMEs indicate the amount of available storage on the page.

space management interval (SMI)

The number of pages controlled by one space management page (SMP).

space management page (SMP)

A page in an area reserved by CA IDMS/DB to keep track of available space on each page in that area. A space management page contains space management entries.

spanned record

1) A database record whose occurrences span VSAM control intervals. 2) A journal record that spans journal blocks.

spawning

The process by which the DBMS creates a new index level to accommodate new members added to a sorted indexed set.

special register

A system-supplied variable defined by CA IDMS/DB for use in an SQL session. You use special registers in place of literals primarily in SQL DML statements. For example, the special register, CURRENT DATE, can be used in WHERE clause selection criteria.

splitting

The process of creating a new system index record (SR8) on the same level as the original system index record.

SQL Communication Area (SQLCA)

A data structure to which the DBMS returns information about the execution of an SQL statement.

SQL database access

A database access method that uses SQL DML to access data and that does not require knowledge of the physical structure of the database. See also navigational database access.

SQL DDL

A data definition language that defines SQL entities such as tables and views.

SQL Descriptor Area (SQLDA)

A data structure to which the DBMS returns information about a prepared SQL statement. The SQLDA values describe the result of the prepared statement.

SQL DML

A data manipulation language that obtains and updates the database by selecting, updating, inserting, and deleting rows in data tables.

SQL function

A builtin aggregate or scalar function or a scalar function created by a CREATE FUNCTION statement.

SQL procedure

The entity created by a CREATE PROCEDURE statement. See also SQL routine, external SQL routine, table procedure.

SQL Quick Bridge

See CA IDMS SQL Quick Bridge.

SQL routine

An SQL procedure, a table procedure, or an SQL function.

SQL schema

A named collection of tables, views, and access modules. You create an SQL schema with the CREATE SCHEMA statement.

SQL session

A database session through which a CA IDMS database can be accessed using SQL DML requests. See also database session, run unit.

SQL statement cache

An area in memory used to store the output from the compilation of a dynamic SQL statement in order to reduce overhead by eliminating redundant compilations.

SQL trace facility

A facility activated by the SQLTRACE SYSIDMS parameter that you can use to trace the execution of SQL statements in a batch program.

SQLCODE

A field in the SQLCA structure that contains a return code indicating the completion status of an SQL statement.

In CA IDMS/DB, one of seven system record types used for space management:

SR1 ── Owner of the system-owned CALC set. An SR1 record occurs once for each page in an area as bytes 5 through 16 in the page header.

SR2 ── A record that replaces records relocated by the RESTRUCTURE SEGMENT utility statement, the migration utility (RHDCMIG1 and RHDCMIG2), and SQL processing following the addition of a column to a table.

SR3 ── A record that identifies a relocated record.

SR4 ── A record that identifies fragments of variable-length records.

SR6 ── A dummy record that appears in the subschema tables as a place holder for excluded owner or member record definitions in set relationships.

SR7 ── Owner record in an index. An SR7 record is stored CALC under the name of the indexed set and occurs once for each indexed set in the database that does not have a user-defined owner record.

SR8 ── A record that contains index entries that point to lower level SR8 records or to an indexed set's member record occurrences.

SREPORTs

Statistics reports that summarize data contained in the archived system log file.

stack

The area at the end of a task control element (TCE) that is used by DC/UCF during task execution as a temporary work area and as a place to save registers.

standalone CA ICMS

A CA ICMS environment in which CA IDMS/DB is not also installed.

standalone record

A database record that is not related to any other record through a set.

standalone table

For maps, an edit or code table defined independently in the data dictionary (by using the TABLE statement). A standalone table can be used by any record element that is associated with a map. See also built-in table.

standard collating sequence

A collating sequence based on the EBCDIC value of the data. See also natural collating sequence.

starting point

Under CA IDMS Dictionary Migrator, this entity and all of its related entities are copied into the object dictionary. You determine what the starting point is by specifying the entry point and whatever option you choose to include in the LEVEL parameter.

startup routine

The module that is executed to begin the DC/UCF startup process. The startup process begins the execution of a DC/UCF system.

statistics reports

See SREPORTs.

status code

A 4-digit code returned by the system to an application program to describe the completion status of a navigational DML command. The first two digits represent a major code; the last two digits represent a minor code.

status definition record

See ADSO-STAT-DEF-REC.

STEP mode

A mode of application execution in which the current screen is redisplayed with messages describing the results of the transaction before control is passed to the next sequential screen. STEP mode is the default in ADSA, ADSC, MAPC, and user-written applications. See also FAST mode.

STEP Mode

An Animation Mode that you specify during an Animation Runtime Session in Interruptable Mode. CA ADS Alive stops at every line of code for the current process. See also SKIP Mode.

storage cushion

Space reserved in a DC/UCF storage pool for use by tasks that are already executing.

storage mode

The characteristic of database records that indicates whether the length of a stored record is fixed (F), variable (V), fixed compressed (FC), or variable compressed (VC). See also location mode.

storage pool

The storage space in memory that is allocated for work areas and control blocks required by DC/UCF system and by programs executing under the DC/UCF system. Typically storage pools hold: program variable storage, COBOL working storage, variable portions of CA ADS dialogs, subschema tables, and access modules, currency blocks, database lock tables, buffer pools, user trace buffers, and secondary allocations of null PDEs. Storage pool specifications are part of a system's definition. See also primary storage pool.

storage protection

A measure that protects pages in the system region/partition from being overwritten.

STORE

The navigational database access function that adds a record occurrence to the database.

STORE logical record

The LRF database access function that adds a logical-record occurrence to the database.

STORE path group

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

stream

An ordered sequence of bytes.

subarea

A subdivision of an area's page range.

subordinate session

A database session initiated while processing a request for another session. Most commonly, a subordinate session is initiated by an SQL routine invoked while processing an SQL request. However, a subordinate session can also be initiated by a database procedure invoked while processing a navigational DML request. See also database session, encompassing session, peer session, top-level session, SQL routine.

subschema

A program view of a non-SQL defined database used at runtime, consisting of all or a subset of the data elements, record types, set types, and areas defined in the schema. Logical-record components are also defined in the subschema.

subschema compiler

A CA IDMS/DB-supplied program that converts source subschema DDL into subschema descriptions. The subschema compiler stores source descriptions in the data dictionary and stores load modules in the DDLDCLOD area.

subschema Data Description Language

The DDL that defines a subschema.

subschema DDL

See subschema Data Description Language.

subschema usage mode

The type of database access permitted to programs that use a particular subschema: logical records only, database records only, or mixed (both logical records and database records).

SUBSCHEMA-CTRL

Names the IDMS communications block through which an application program and the DBMS communicate.

SUBSCHEMA-LR-CTRL

Names the logical-record request control (LRC) block through which an application program and LRF communicate.

subsystem

An IDD entity type used to document automated or manual data processing systems. See also system.

suspense file

In CA ADS Batch, a file defined to store input records found to contain edit errors at runtime.

SVC

See CA IDMS SVC.

sweep the database

See area sweep.

symbol table

A dialog generation option used to specify whether or not a symbol table is created for a dialog. The symbol table facilitates the use of element names and process line numbers by the online debugger.

symbolic key

One or more user-defined record elements used to store or retrieve data, as determined by application requirements. The key can be a primary key, foreign key, or some other meaningful element in the record. Under CA IDMS/DB, keys are used to store data through the CALC location mode and/or to sort data in indexed and chained sets. Database keys (db-keys) are not symbolic keys.

symbolic parameter

A parameter that connects a generic logical definition of a subarea, displacement, or index to a specific definition in the physical database definition. With symbolic parameters, multiple physical databases can use the same schema definition.

synchronization stamp

An internally-generated timestamp used to ensure that the definition of a table matches the data being accessed.

synonym

An alternative name that is defined for an entity in the data dictionary. Synonyms are defined in DDDL statements or in the schema.

syntax converter

In IDD, the facility that captures COBOL or PL/I record and element definitions and adds them to the data dictionary.

syntax files

Under CA IDMS Dictionary Migrator, a collection of files that contain source statements used as input to the CA IDMS utilities and compilers. The syntax files permit completion of the movement of entities and entity components from one or more source dictionaries to the object dictionary.

SYSCA schema (SQL)

At sites with the SQL option, the schema that contains the CA-supplied views of the SYSTEM tables and records in the IDMSNWK schema. These views restrict access to table definition information based on a user's SELECT authority. See also SYSTEM schema (SQL).

SYSCTL file

A file used by a batch or CICS application to direct its CA IDMS requests to a target system and/or database. The SYSCTL file contains values that define the DC/UCF system, CA IDMS SVC, node, and database the program will use.

sysgen

An abbreviation for system generation. See also system generation.

SYSIDMS parameter file

A parameter file added to the JCL stream of batch jobs running in local mode or under the central version. It specifies: physical requirements of the environment, such as the DMCL and database to use at runtime; runtime directives that assist in application execution; operating system-dependent file information.

system

1) A DC/UCF system or central version. 2) An IDD entity type used to document automated or manual data processing systems. See also subsystem.

system 90

The executable demonstration system generated at installation time. This system provides the batch simulator system used to run demonstration jobs. Later in the installation procedure, system 90 can optionally be generated as an online system with one terminal (the console) and any number of specified users.

system 99

A DC/UCF system that is generated at installation time. System 99 provides a sample system configuration. This base system can be used to generate other DC/UCF systems.

system dictionary

The dictionary that includes all information required to establish, maintain, and control the processing environment. It contains the DC/UCF system definition and physical database definitions. Each runtime environment must have a system dictionary named SYSTEM which contains the following areas: DDLDML, DDLDCLOD, DDLDCMSG, DDLCAT, DDLCATX, and DDLCATLOD.

system function

1) In CA ADS, a predefined function available to ADSA-generated applications. The system functions are POP, POPTOP, TOP, RETURN, HELP, QUIT, ESCAPE, SIGNON, SIGNOFF, FORWARD, and BACKWARD. A system function is incorporated into an application when that function has been associated with a valid response. 2) A DC/UCF system task (such as SIGNON, DCMT, and DCUF).

system generation

The process of using the system-generation compiler to populate the data dictionary with the definition of a DC/UCF system.

system index

A standalone index structure providing alternate access to entity occurrences. The root (or top index entity) is an SR7 entity occurrence. This is an internal record type with a location mode of CALC.

system log

See log.

system mode

The execution mode in which a program can access all storage pages in the DC/UCF region/partition.

system photo

The information at the beginning of a system or task snap that shows all currently executing tasks and the resources allocated to each task.

system profile

A profile that includes attributes that apply to users of a specific DC/UCF system. For example, a system profile might identify the name of a dictionary a user can access. See also user profile.

system record

In CA IDMS/DB, one of the nine system record types (for example, SR1 and K0). System records are used internally by CA IDMS/DB to perform space management functions.

system reports

See CREPORTs.

system resource

Within centralized security, an entity shared system-wide by CA IDMS processing under the central version. See also global resource, database resource.

system run unit

A run unit initiated by the DC/UCF system as part of providing a standard service such as writing a message. You can predefine system run units. See also predefined run unit.

SYSTEM schema (SQL)

At sites with the SQL option, the schema associated with the tables that comprise the catalog component of the dictionary. See also SYSCA schema (SQL).

system storage pool

See primary storage pool.

system task

A CA IDMS supplied task that performs one of a variety of DC/UCF system support services at runtime. System tasks include the DCMT, DCUF, SIGNON, and SIGNOFF tasks.

system trace

The DC/UCF debugging aid that records the system service modules used in processing a DC/UCF request in a trace table. When a program issues a SNAP request, DC/UCF writes the trace table to the log.

system-generation compiler

A CA IDMS/DB-supplied program that accepts source statements defining a DC/UCF system and stores the definition in the data dictionary.

system-owned indexed set

An indexed set in which the owner record is a system-defined SR7 record. The location mode of an SR7 record is CALC on the set name for non-SQL defined indexes or on an internally-generated name for SQL- defined indexes. There is at most one occurrence of an SR7 record for each system-owned index. See also user-owned indexed set.