Previous Topic: CA IDMS DML Control StatementsNext Topic: Using FIND/OBTAIN Commands

Commands › CA IDMS DML Retrieval Statements

CA IDMS DML Retrieval Statements

The following is a list of CA IDMS DML retrieval statements in the formats accepted by CA IDMS DMLO:

Format 1

< FIND   > [KEEP [EXCLusive]] [record-name] DB-KEY [IS] <   KEYn        >
\ OBTain /                                              \ dbkey-literal /

Format 1B

< FIND   > [KEEP [EXCLusive]]  DB-KEY [IS] <   KEYn        >
\ OBTain /                                 \ dbkey-literal /
     PAGE-INFO  <     PGRn      >
                 \ pgr-literal /

Format 2

 
 < FIND   > [KEEP [EXCLusive]] CUrrent record-name
 \ OBTain /

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

Format 3

                               / Next   \
                               │ PRior  │
 < FIND   > [KEEP [EXCLusive]] < First  > [record-name]
 \ OBTain /                    │ Last   │
                               \ number /

       / WIthin \ / set-name  \
       < IN     > < area-name >
                              

Format 4

< FIND   > [KEEP [EXCLusive]] OWner < WIthin > set-name
\ OBTain /                          \ IN     /

Format 5

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

Format 6

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

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