Edit database location


The Data Base Location screen, shown in the following figure, is used to control the editing of your database. This screen is initially displayed after you press ENTER on the Data Base Dataset Specification screen for a DL/I region type or after processing the BMP Region Type Specification screen for a BMP region type. There is a pause before the screen is displayed because File-AID for IMS is loading the IMS program load modules and establishing the control region within your TSO address space. IMS remains active until you either move backward in the edit conversation from this screen or terminate the conversation.

EDIT - Data Base Location screen

File-AID for IMS  ---  EDIT - Data Base Location  ----------------- LINE  00001
COMMAND ===>                                                   SCROLL ===> PAGE  

Line                                        Key                Key
Cmd -----Level----- Segment- --Description-Length-------------Value------------
__* 1 DBD-LORDR     ORDR010  ORDER ROOT      006
__   2              ORDR020  ORDER LINE      002
__    3             ORDR030  ORDER STATUS    002
__   2              ORDR040  ORDER SCRAP     008
__   2              ORDRCUST ORDR-CUST CNCAT 002
                         *** END OF SEGMENT LIST ***  










S  -- Select Formatted        K  -- Key Specification, then Select Formatted
SU -- Select Unformatted      KU -- Key Specification, then Select Unformatted
SC -- Select Character        KC -- Key Specification, then Select Character

Line Cmd

Used to select a segment for editing. For more information, see Selecting a Segment.

Level

Displays the segment type’s hierarchical level number in the database. For the root segment type, the primary DBD name is displayed beside the level number.

Segment

Indicates the segment name as specified in the DBD.

Description

Displays a 15-character segment description. This description is retrieved from the segment/layout cross-reference created in Option 7.

Key Length

Displays the segment key length. If the segment is non-keyed, zero is displayed.

Key Value

Displays up to 30 characters of the key value for each segment type. Additional information about this field is provided in the next section.

Selecting a Segment

When you initially enter the Data Base Location screen, your current position in the database is dependent on the type of database being edited.

For a database defined without a randomizing routine, the first root segment occurrence is retrieved and the key is placed in the Key Value column on the root segment line as shown in EDIT - Data Base Location Screen - Selecting a New Segment. File-AID for IMS considers this root segment occurrence to be your current position in the database.

For an HDAM database, File-AID for IMS allows the user to specify a key value to retrieve the first segment in the database. This process reduces IMS’s search time to retrieve a root segment for a database defined with a randomizing routine.

The Data Base Location screen indicates your current position by placing an asterisk in the Line Cmd field of all segment types in the hierarchical path to your current position. The first 30 positions of the key value for each segment occurrence in the hierarchical path to your current position are also shown.

EDIT - Data Base Location Screen - Selecting a New Segment

File-AID for IMS  ---  EDIT - Data Base Location  ----------------- LINE  00001
COMMAND ===>                                                   SCROLL ===> PAGE  

Line                                        Key                Key
Cmd -----Level----- Segment- --Description-Length-------------Value------------
__* 1 DBD-PORDR     ORDR010  ORDER ROOT      006 AA2222
__   2              ORDR020  ORDER LINE      002 01
S_    3             ORDR030  ORDER STATUS    002 01
__   2              ORDR040  ORDER SCRAP     008
__   2              ORDR050  ORDR-CUST LCHLD 002
                         *** END OF SEGMENT LIST ***  









S  -- Select Formatted        K  -- Key Specification, then Select Formatted
SU -- Select Unformatted      KU -- Key Specification, then Select Unformatted
SC -- Select Character        KC -- Key Specification, then Select Character

To change your current segment position from the Data Base Location screen, first enter the key value for each segment type in the hierarchical path to the segment occurrence you want. Then enter one of the six valid line commands shown at the bottom of the Data Base Location screen in the Line Cmd column of the segment type you want (see EDIT - Data Base Location Screen - Selecting a New Segment). File-AID for IMSretrieves the new segment occurrence and then, based on the line command you specify, does one of the following:

S

Enters the formatted editing mode (here).

SU

Enters the unformatted editing mode (here).

SC

Enters the character editing mode (here).

K

Displays the Key Specification screen (here) and then enters the formatted editing mode.

KU

Displays the Key Specification screen and then enters the unformatted editing mode.

KC

Displays the Key Specification screen and then enters the character editing mode.

To retrieve the first segment in an HDAM database, you must enter one of the six valid line commands and, optionally, a key value on either the Data Base Location screen or KEY Specification screen. If a key value is not specified on the Data Base Location screen with line commands S, SU, or SC, File-AID for IMS retrieves the first root segment.

Use the K, KU, or KC line commands when you need greater flexibility to specify key values than the Data Base Location screen allows. By using one of these line commands to proceed to the Key Specification screen before entering an editing mode, you can, for example, enter key values greater then 30 characters in length. The Key Specification screen is described in detail on here.

To specify the key values in the hierarchical path to a segment occurrence, you can leave any or all of the Key Value fields blank. If you leave the Key Value field blank on the segment type you select, File-AID for IMS formats an unqualified SSA at that level and IMS retrieves the first occurrence of that segment type in the specified hierarchical path.

If you enter a key for the segment type you select but leave the Key Value field blank for one of its parent segment types, File-AID for IMS formats an unqualified SSA at the parent’s level and IMS searches through each occurrence of that parent segment type in the specified hierarchical path. The search stops when an occurrence of the segment type you selected is found with a key value that matches the one you entered or when all occurrences of the parent without a key entered are searched. For example, in EDIT - Data Base Location Screen - Leaving Key Field Blank, File-AID for IMS formats the SSAs so that IMS searches through all occurrences of the ORDR020 segment type that exist under the ORDR010 root with a key equal to AA2222, looking for an occurrence of the ORDR030 segment type with a key of 01.

If the correct ORDR030 segment occurrence is found, you then enter the unformatted editing mode with that ORDR030 segment as your current segment.

If the correct ORDR030 segment cannot be found, an error message is displayed on the Data Base Location screen.

If, in the example, both the ORDR010 and ORDR020 Key Value fields are blank when the ORDR030 segment type is selected, File-AID for IMS formats the SSAs so that IMS searches for the first ORDR030 occurrence in the database with a key value of 01. If all three Key Value fields are blank, IMS retrieves the first ORDR030 occurrence in the database.

EDIT - Data Base Location Screen - Leaving Key Field Blank

File-AID for IMS  ---  EDIT - Data Base Location  ----------------- LINE  00001
COMMAND ===>                                                   SCROLL ===> PAGE  

Line                                        Key                Key
Cmd -----Level----- Segment- --Description-Length-------------Value------------
__* 1 DBD-PORDR     ORDR010  ORDER ROOT      006 AA2222
__   2              ORDR020  ORDER LINE      002
SU    3             ORDR030  ORDER STATUS    002 01
__   2              ORDR040  ORDER SCRAP     008
__   2              ORDR050  ORDR-CUST LCHLD 002
                         *** END OF SEGMENT LIST ***  









S  -- Select Formatted        K  -- Key Specification, then Select Formatted
SU -- Select Unformatted      KU -- Key Specification, then Select Unformatted
SC -- Select Character        KC -- Key Specification, then Select Character

When a segment type is non-keyed, File-AID for IMS formats an unqualified SSA at that level, which results in the same processing as for segment types that you do not enter key values for.

When key values of 13 positions or less in length are specified, you can enter the hexadecimal representation of the key value. The format is X’nnnn...’, where each n digit is one half-byte of hex data. You must enter an even number of digits when using this format.

When a key value in character or hexadecimal format is specified and the value you enter is shorter than the length shown in the Key Length column, File-AID for IMS blank pads the key value on the right.

The Data Base Location screen always shows the hierarchical path to the segment occurrence in the database that is the current position with asterisks and key values. The Data Base Location screen saves those key values and displays them each time you return to the screen. Saved key values are updated for each segment in the current hierarchical path each time you return to the Data Base Location screen.

Key values that are not in the current hierarchical path are not updated. Saved key values can be updated by typing over them, whether or not they are in the current hierarchical path. For example, in Edit - Data Base Location Screen - Saved Key Values, the hierarchical path to the current segment position includes segment types ORDR010 and ORDR040 with key values of AA2222 and 01C7477A, respectively. Those two key values are displayed each time you return to the Data Base Location screen until different occurrences of the ORDR010 and ORDR040 segment types are part of the current hierarchical path or until you change the key values.

The last time this screen was displayed, ORDR020 and ORDR030 were in the current hierarchical path with key values of 01. The last time that ORDR050 was in the current hierarchical path, it did not show the key value of 01. This value was typed in manually.

The Data Base Location screen saves prior key values to enable you to easily re-position to previously selected segment occurrences.

Edit - Data Base Location Screen - Saved Key Values

File-AID for IMS  ---  EDIT - Data Base Location  ----------------- LINE  00001
COMMAND ===>                                                   SCROLL ===> PAGE  

Line                                        Key                Key
Cmd -----Level----- Segment- --Description-Length-------------Value------------
__* 1 DBD-PORDR     ORDR010  ORDER ROOT      006 AA2222
__   2              ORDR020  ORDER LINE      002 01
__    3             ORDR030  ORDER STATUS    002 01
__*  2              ORDR040  ORDER SCRAP     008 01C7477A
__   2              ORDR050  ORDR-CUST LCHLD 002 01
                         *** END OF SEGMENT LIST ***  









S  -- Select Formatted        K  -- Key Specification, then Select Formatted
SU -- Select Unformatted      KU -- Key Specification, then Select Unformatted
SC -- Select Character        KC -- Key Specification, then Select Character

Inserting a Segment

The INSERT primary command is the only database update command supported on the Data Base Location screen. With it you can insert new segment occurrences into a database. This command functions on the Data Base Location screen as described in INSERT (Edit only).

Although you can insert any segment type from the Data Base Location screen at any time during your edit session, this screen is primarily intended to be used for inserting the first root segment in an empty, initialized database. You cannot select an editing mode from the Data Base Location screen while in an empty database until you insert a root segment.

The RECOVERY, SAVE, and CAPS commands are three additional primary commands you can use on this screen (RECOVERY and SAVE are not supported in browse mode). Each of these commands is described in Common Edit Primary Commands.

Edit Database Location Primary Commands

The ZOOM and ZOOMH primary commands can be used on the Data Base Location screen.

ZOOM

The ZOOM primary command opens a panel that enables you to modify key values of segments that display on the Data Base Location screen. The ZOOM command is available for fields defined as character format with length less than or equal to 600 bytes and containing all displayable characters.

Important

Executing the ZOOM command for key values that exceed 600 bytes or contain non-displayable characters automatically displays the ZOOMH Edit Panel.

To display the ZOOM Edit panel, execute the ZOOM primary command while your cursor is on the key value you wish to zoom in the Data Base Location screen (EDIT - Data Base Location Screen). This panel enables you to edit key values with length exceeding 30 characters.

ZOOM Edit Panel

ZOOM EDIT - CW.FISAMP.ORDER ---------------------------------- (DBD-PORDR   )-
 COMMAND ===>
 PARENT:
 SEGMENT:   ORDR010

 DATA NAME: *** KEY VALUE ***
 FORMAT:    C   6  K

 AA2222






                           ENTER END COMMAND TO RETURN

The following primary commands can be used on the ZOOM Edit panel:

CANCEL

Restores the key value to what existed before you changed it.

END

Terminates the ZOOM Edit panel and returns you to the previous Edit Data Base Location screen.

HEX ON

Displays the ZOOMH Edit panel and shows the key value in three-line vertical HEX format.

RETURN

Returns you to the Primary Option menu.

ZOOMH

Displays the ZOOMH Edit panel and shows the key value in three-line vertical HEX format.

ZOOMH

The ZOOMH primary command opens a panel that enables you to edit segment key values in three-line vertical HEX mode. The ZOOMH command is available for variable length key values containing displayable characters and non-displayable hexadecimal values.

To display the ZOOMH Edit panel, execute the ZOOMH primary command on the Data Base Location screen while your cursor is on the key value you wish to zoom in hexadecimal format. The key value is displayed in a scrollable panel in three-line vertical hexadecimal format, identical to the Edit Unformatted - HEX mode (Unformatted Screen - Hex Mode).

The top line of the HEX display represents the character format of the current key value, the middle line represents the upper half-byte of each character in HEX, and the third line represents the lower half-byte of each character in HEX. When a character is not displayable, it is represented by a period (.) on the top line. To change a key value, type over the character or the HEX line. If you type over both the character and HEX lines for the same character, the character type over is ignored.

ZOOMH Edit Panel

 ZOOMH EDIT - CW.FISAMP.ORDER --------------------------------- (DBD-PORDR   )-
 COMMAND ===>                                                   SCROLL ===> PAGE
 PARENT:
 SEGMENT:   ORDR010

 DATA NAME: *** KEY VALUE ***
 FORMAT:    C   6  K
       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7

     1 AA2222
       CCFFFF
       112222
       ----+----*----+----*----+----*----+----*----+----*----+----*----+----*










                           ENTER END COMMAND TO RETURN 

The following primary commands can be used on the ZOOMH Edit panel:

CANCEL

Restores the key value to what existed before you changed it.

END

Terminates the ZOOMH Edit panel and returns you to the previous Edit Data Base Location screen.

HEX OFF

Displays the ZOOM Edit panel and shows the key value in character format.

RETURN

Returns you to the Primary Option menu.

ZOOM

Displays the ZOOM Edit panel and shows the key value in character format.

Important

If you execute the HEX OFF or ZOOM commands for key value fields that exceed 600 bytes and contain non-displayable characters, you will remain on the ZOOMH Edit panel and receive an informational message.

Terminating the Screen

If using a dynamic PSB, do one of the following to terminate the Data Base Location screen:

  • Enter the END command. The Data Base Specification screen is displayed.
  • Enter the RETURN command to return to the Primary Option Menu.

After you enter one of these commands, the processing under the IMS batch region is terminated, which causes the IMS Resource Manager to display message "DFS627I" at your terminal. This message indicates whether the resource cleanup operation initiated by the IMS Resource Manager succeeded or failed. This message can be suppressed by setting your TSO user profile option WTPMSG to NOWTPMSG.

If using a static PSB and you selected only one DBD, follow the same procedure as if using a dynamic PSB to terminate the Data Base Location screen.

If using a static PSB and you selected more than one DBD, do one of the following to terminate the Data Base Location screen:

  • Enter END. The DBD Selection List for Static PSB screen is displayed. The screen now includes only the selected entries. Enter S to select the next DBD.
  • Enter END to return to the Data Base Specification (Static) screen.
  • Enter RETURN to return to the Primary Option Menu.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*