Database Positioning panel

You use the Database Positioning panel to specify the position in the database at which you want to start editing or browsing, and the format in which you want the data displayed.

When you return to the Database Positioning panel after editing or browsing a database, the panel uses the Pos and Key value fields to indicate your position in the database when you left the IMS data panel.

If you are using a dynamic PSB, then the panel lists all segment types in the DBD.

If you are using a static PSB, then the panel lists segment types in the DBD that the PCB is sensitive to.

Panel and field definitions

Figure 1. Database Positioning panel
 Process   Options   Help
────────────────────────────────────────────────────────────────────────────────
FM/IMS                   Edit : Database Positioning

Subsystem IF52  Database DJ1E      Key sequence                   Format TABL
View C   Temporary                          Key
Cmd SXE Level     Segment   Description     len  Key value
    SX  1         SHIRE                      20
     X   2        SHIRENP                     0
     XE  2        LINKSUB                    18  ..................
   **** End of data ****





Command ===>                                                       Scroll CSR
 F1=Help      F2=Split     F3=Exit      F4=CRetriev  F5=Key >=    F7=Backward
 F8=Forward   F9=Swap     F10=Actions  F12=Cancel
Subsystem
The subsystem ID you specified on the Edit Entry panel.
Database
This displays the name of the DBD entered on the Edit Entry or Browse Entry panel. This line also contains the Key sequence for the following types of database: HSAM, SHSAM, HISAM, SHISAM, HIDAM, GSAM, INDEX, MSDB.
View
This displays the View data set and member being used. If you are not using a view on this session, this displays as None. If the view is generated from a template (a new view), the name displayed is “Temporary?. If this view has been changed (by line or primary commands), a C indicator is shown until the view is saved.
Cmd
The line command field. Line commands available on this panel are:
E (Edit)
Enter e in the Cmd field of the segment type you want to edit the view for. This is only available when a view is used.
K (Key value)
Enter k in the Cmd field of the segment type you want to display, to display the Key Specification panel. On this panel you can specify the key fields of all segment types in the hierarchical path of the segment type you selected.
S (Position)
Enter s in the Cmd field of the segment type you want to position on to begin retrieval of segments for the data display panels and specify the key values in the Key value field(s) for all the segment types in the hierarchical path of the segment occurrence you want. Pressing ENTER uses the entered specific key values as an equals search. When used with the GE command (assigned by File Manager to function key F5), you can enter a partial key in the key value field. For example, entering a S in the Cmd field a M in the root segment key value field and press F5 to display segments starting from those whose root segments start with M. For database types that are not key-sequenced, you must enter a specific key at the root segment level (even when using the GE command), but you may enter a partial key at lower levels.
X (Select)
Enter x in the Cmd field of the segment type you want to alter the view to select or deselect. Again, this is only available if a view is being used.

Use this field to specify the position at which you want to start editing.

SXE
Denotes three columns of information:
S
Shown when the segment type is in the hierarchical path of the current position, is blank otherwise.
X
Is shown for those segments that are selected for display by the current view. If no view is used, all segments are considered selected.
E
Is shown for those segments that have selection expression or expressions in the current view.
Level
The hierarchical level of the segment type in the database.
Segment
The name of the segment type.
Description
If you are using a view, then this is the segment description (specified when you create a template). Otherwise, the field is blank.
Key len
The length of the key of the segment type.
Key value
When you return to this panel after editing a database, and the segment type is in the hierarchical path of the position where you finished editing, then this field contains the key value at that position. Otherwise, this field contains binary zeros.

When you first display this panel (before editing the database), if the database organization stores root segments in key sequence, then this field contains the key value of the first root segment in the database.

The key value is displayed as unformatted characters. Binary and packed decimal numeric field values are not displayed as their formatted numeric values, even if you are using a view.

You can issue the HEX ON command to display the hexadecimal contents of the key value in a format similar to that used within the editor, where the hexadecimal values are shown underneath the key characters.

If the key is longer than thirty characters, then its value wraps onto the next line on the panel.

Parent panels

Child panels

Related topics and examples