Commands › CA IDMS DML Retrieval Statements › Using FIND/OBTAIN Commands

Using FIND/OBTAIN Commands

In the FORMAT 3 FIND/OBTAIN the clause 'WITHIN set-name/area-name' may be omitted. If omitted, this will default to 'WITHIN area-name' and CA IDMS DMLO will determine the correct area-name for the record requested.

FORMAT 1, 5, and 6 of the FIND/OBTAIN commands require definition of a symbolic key or database key before execution. The following discussion explains how to execute these commands in the CA IDMS DMLO environment.

Format 1

< FIND   > [KEEP [EXCLusive]] [record-name] DB-KEY [IS] <   KEYn        >

\ OBTain /                                              \ dbkey-literal /

The Format 1 FIND/OBTAIN command requires a database key. The db-key value may be provided as a literal or in one of the ten CA IDMS DMLO KEYPAD fields. The dbkey-literal may be specified as PPPPPP-LLLL (page-line format), X'hhhhhhhh' (hexadecimal format), or F'nnnnnnnnn' (decimal format).

A value may be established in the KEYn KEYPAD by using one of the following commands:

1. ACCEPT KEYn FROM ..... CURRENCY
2. RETURN KEYn FROM .....
3. MOVE ..... TO KEYn

Format 1B

< FIND   > [KEEP [EXCLusive]]  DB-KEY [IS] <   KEYn        >  PAGE-INFO  <     PGRn     >

\ OBTain /                                 \ dbkey-literal /              \ pgr-literal /

The PAGE-INFO value may be provided as a literal or in one of the ten CA IDMS DMLO PGR0 - PGR9 KEYPAD fields. The pgr-literal may be specified as X'hhhhhhhh' (hexadecimal format) or F'nnnnnnnn' (decimal format).

A value may be established in the PGRn KEYPAD by using one of the following commands:

ACCEPT PGRn FOR record-name
ACCEPT KEYn FROM ... CURRENCY

Format 5

                              / CALC      \
< FIND   > [KEEP [EXCLusive]] < ANY       > record-name
\ OBTain /                    \ DUPlicate /

To execute a FORMAT 5 FIND/OBTAIN CALC command you must set the record elements comprising the calc key. To accomplish this use one of the following procedures:

• Using the Data Manipulation Screen
  1. Display the record type to be retrieved.
  2. Enter appropriate data in the calc key field(s).
  3. Press the ENTER key.
  4. Enter the FORMAT 5 command in the command area.
  5. Press the ENTER key or a PF key.
• Using the Command Line (Option 1)
  1. MOVE key-value TO sort-key-field (for each element of sort key)
  2. Enter the FORMAT 6 command and press the ENTER key or a PF key.
  3. Using the Command Line (Option 2)
• Enter the format 6 command with an appropriate literal and press the ENTER key or a PF key.

Format 6

 
 < FIND   > [KEEP [EXCLusive]] record-name < WIthin > area-name
 \ OBTain /                                \ IN     /

                             / SORTKEY    \
   set-name [CUrrent]  USing < field-name >
                             \ literal    /

The Format 6 FIND/OBTAIN USING command needs the symbolic key of a sorted set key to execute.

The method for executing the Format 6 statement is similar to the method used to execute the Format 5 statement. However, the Format 6 statement pertains to indexed records and sorted sets.

To execute this statement CA IDMS DMLO must be given the value of the sorted or index key.

To supply CA IDMS DMLO with the information, use one of the following methods:

• Using the Data Manipulation Screen
  1. Display the record type to be retrieved.
  2. Enter appropriate data in the sort key field(s).
  3. Press the ENTER key.
  4. Enter the Format 6 command and press the ENTER key or a PF key.
• Using the Command Line (Option 1)
  1. MOVE ... sort-key-field
  2. Enter the Format 6 command press the ENTER key or a PF key.
  3. Using the Command Line (Option 2)
• Enter Format 6 command with literal of appropriate type.