Command code reference

Use the following reference information for the command codes.

Restriction: Command codes cannot be used by MSDB calls.
Restrictions: The following restrictions apply for Fast Path secondary index command code and multiple SSA support:
  • The C command code cannot be specified in any SSA other than the first SSA. If specified, it will be rejected with a status code of AJ.
  • The V command code for an ISRT call is ignored.
  • A, G, and subset pointer related command codes (M, R, S, W, and Z) are not supported. They are rejected with a status code of AJ.
Restrictions: The following restrictions apply for any DL/I call for a physical parent segment of the target segment where target segment is not the root segment:
  • The P, Q, U, and V command codes are ignored.
  • The field name must be the sequence field name for the parent segment if the SSA contains a qualification statement. If any field name other than the sequence field name is specified, it will be rejected with a status code of AK.
Table 1. Summary of command codes
Command code  Description
A Clear positioning and start the call at the beginning of the database.
C Use the concatenated key of a segment to identify the segment.
D Retrieve or insert a sequence of segments in a hierarchic path using only one call, instead of using a separate (path) call for each segment.
F Back up to the first occurrence of a segment under its parent when searching for a particular segment occurrence. Disregarded for a root segment.
G Prevent randomization or the calling of the HALDB Partition Selection exit routine and search the database sequentially.
L Retrieve the last occurrence of a segment under its parent.
M Move a subset pointer to the next segment occurrence after your current position. (Used with DEDBs only.)
N Designate segments that you do not want replaced when replacing segments after a Get Hold call. Typically used when replacing a path of segments.
O Either field names or both segment position and lengths can be contained in the SSA qualification for combine field position.
P Set parentage at a higher level than what it usually is (the lowest-level SSA of the call).
Q Reserve a segment so that other programs cannot update it until you have finished processing and updating it.
R Retrieve the first segment occurrence in a subset. (Used with DEDBs only.)
S Unconditionally set a subset pointer to the current position. (Used with DEDBs only.)
U Limit the search for a segment to the dependents of the segment occurrence on which position is established.
V Use the hierarchic level at the current position and higher as qualification for the segment.
W Set a subset pointer to your current position, if the subset pointer is not already set. (Used with DEDBs only.)
Z Set a subset pointer to 0, so it can be reused. (Used with DEDBs only.)
- Null. Use an SSA in command code format without specifying the command code. Can be replaced during execution with the command codes that you want.

The following table shows the list of command codes with applicable calls.

Table 2. Command codes and related calls
Command Code GU GHU GN GHN GNP GHNP   REPL   ISRT   DLET
A   X        
C X X X   X  
D X X X   X  
F X X X   X  
G   X        
L X X X   X  
M X X X X X  
N       X    
O X X X   X  
P X X X   X  
Q X X X   X  
R X X X   X  
S X X X X X  
U X X X   X  
V X X X   X  
W X X X X X  
Z X X X X X X
- X X X X X X