Support for COPE managed database in BMP region (Static PSB)
If your IMS environment definition includes support for COPE Managed Databases, the Data Base Specification Screen displays as shown in the following figure.
Data Base Extract - Data Base Specification Screen (COPE Managed Databases)
COMMAND ===>
ENV: EC01 - IMS 14 COPE ENV LSYS=IEC01
COPE MANAGED DATABASE - BMP REGION
Specify members for the "FROM" data base:
DBD Member . . DBFSAMD3 (Blank to select from list in PSB)
-------------------------------------------------------------------------------
Use secondary indexing . . Y (Y = Yes; N = No)
-------------------------------------------------------------------------------
Segment or Secondary Index "Key values" may be supplied in a separate dataset.
Extract based on key values . . Y (Y = Yes; N = No)
Specify the dataset that contains the "key values" below:
"keys" dataset . . ‘CW.FISAMP.KEYFILE’
Member . . KEYFILE (Blank or pattern for member list)
Current Environment
The top of the screen displays the environment definition name with its description that is in effect for the current session. It also includes a line identifying the extent of the COPE support, for example:
DBD Member
Enter the member that describes the database from which you want to extract (that is, the FROM database). The DBD member entered must describe a physical database. Logical and index DBDs are not supported. Leave the member blank to select the DBD from the list of PCBs in the static PSB.
Use Secondary Indexing
Determines whether a secondary index will be used to drive extract processing.
Enter one of the following:
Y | Secondary indexing will be used. If this option is selected, a key file of secondary index key values may be used with or without additional selection criteria, or selection criteria may be defined on secondary index key fields. |
N | Secondary indexing will not be used during extract processing. |
Extract Based on Key Values
Defines whether an external data set containing database key values will be used to drive the extract. These key values may be ROOT keys, fully qualified concatenated keys or if you have chosen to use a secondary index to drive extract processing, the data set may contain secondary index values.
Enter one of the following:
N | An external data set will not be used to drive the extract. |
Y | An external data set containing database key values will be used to drive the extract. These key values may be ROOT keys, fully qualified concatenated keys or if you have chosen to use a secondary index to drive extract processing, the data set may contain secondary index values. |
Keys" dataset
Specify the keys dataset that contains the key values for extract.
Member
Specify the member in the keys dataset that contains the key values for the extract. For additional information, see Member.
Terminating the Screen
Do one of the following to terminate the Data Base Extract - Data Base Specification screen (dynamic PSB):
- Press Enter to advance to the next screen in the conversation.
- If you chose to use secondary indexing, the Secondary Index Data Base List screen is displayed.
- If you did not choose to use secondary indexing, the Data Base Extract Option Specification screen (Data Base Extract - Option Specification Screen) is displayed.
- Enter the END command to return to the Extract/Load Data Base Menu or the Primary Option Menu. The screen you return to is determined by where you started the conversation.
- Enter the RETURN command to return to the Primary Option Menu.
Related topics