Common Data Management Resources

This topic identifies all the data management resources that follow data management scoping rules. Following each resource is a brief description of how to specify the scoping. Additional details for each resource can be found in the publications referred to.

Open file operations : Open file operations result in the creation of a temporary resource that is called an open data path (ODP). You can start the open function by using HLL open verbs, the Open Query File (OPNQRYF) command, or the Open Data Base File (OPNDBF) command. The ODP is scoped to the activation group of the program that opened the file. For OPM or ILE programs that run in a default activation group, the ODP is scoped to the call-level number. To change the scoping of HLL open verbs, you can use an override. You can specify scoping by using the open scope (OPNSCOPE) parameter on all override commands, the OPNDBF command, and the OPNQRYF command.

Overrides : Overrides are scoped to the call level, the activation group level, or the job level. To specify override scoping, use the override scope (OVRSCOPE) parameter on any override command. If you do not specify explicit scoping, the scope of the override depends on where the system issues the override. If the system issues the override from a default activation group, it is scoped to the call level. If the system issues the override from any other activation group, it is scoped to the activation group level.

Commitment definitions : Commitment definitions support scoping to the activation group level and scoping to the job level. The scoping level is specified with the control scope (CTLSCOPE) parameter on the Start Commitment Control (STRCMTCTL) command. For more information about commitment definitions, see the Backup and Recovery topic in the IBM® i Information Center.

Local SQL cursors : SQL cursors can be declared and used within user built applications or within Database constructed ILE C programs or ILE C service programs built on behalf of CREATE PROCEDURE, CREATE FUNCTION, or CREATE TRIGGER LANGUAGE SQL statements.

For all types of
SQL applications, there are SQL cursor scope controls. The cursor scope controls include an option
to scope cursors to the activation group, as well as several other scope choices.

For complete details, refer to [IBM i DB2® for i SQL
Reference](../pdf/rbafzpdf.pdf "(Opens in a new tab or window)").

Remote SQL connections : Remote connections used with SQL cursors are scoped to an activation group implicitly as part of normal SQL processing. This allows multiple conversations to exist among either one source job and multiple target jobs or multiple systems.

User interface manager : The Open Print Application (QUIOPNPA) and Open Display Application APIs support an application scope parameter. These APIs can be used to scope the user interface manager (UIM) application to either an activation group or the job. For more information about the user interface manager, see the API topic under the Programming category of the IBM i Information Center.

Open data links (open file management) : The Enable Link (QOLELINK) API enables a data link. If you use this API from within a non-default activation group, the data link is scoped to that activation group. If you use this API from within a default activation group, the data link is scoped to the call level. For more information about open data links, see the API topic under the Programming category of the IBM i Information Center.

Common Programming Interface (CPI) Communications conversations : The activation group that starts a conversation owns that conversation. The activation group that enables a link through the Enable Link (QOLELINK) API owns the link. For information about Common Programming Interface (CPI) Communications conversations, see the API topic collection under the Programming category of the IBM i Information Center.

Hierarchical file system : The Open Stream File (OHFOPNSF) API manages hierarchical file system (HFS) files. You can use the open information (OPENINFO) parameter on this API to control scoping to either the activation group or the job level. For more information about the hierarchical file system, see the API topic under the Programming category of the IBM i Information Center.