Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Function codes of the DML statements

&pagelevel(3)&pagelevel

The following table shows the function codes in decimal notation.

Function
code

Short function
name

Meaning

0

START

Start a user program

1

FINISH

FINISH

2

ERASUN

ERASE record-name

3

ERASQU

ERASE record-name {PERMANENT/SELECTIVE/ALL}

4

FND1

FIND-1

5

FND5

FIND-5

6

FND4R

FIND-4 without WITHIN or with WITHIN realm-name

7

FND4S

FIND-4 WITHIN set-name

8

FND6

FIND-6

9

FND2

FIND-2

10

FND7IS

FIND-7 USING record-element-name,... (sequential search)

11

FND7IK

FIND-7 USING record-element-name,... (search with key)

12

FND3IS

FIND-3 USING record-element-name,... (sequential search)

13

FND3IK

FIND-3 USING record-element-name,... (search with key)

15

CONNEC

CONNECT

16

MODIFY

MODIFY

17

ACCEPT

ACCEPT

18

READY

READY

19

DISCON

DISCONNECT

20

STORE

STORE

21

STOP

End a user program

22

FREE

FREE

23

KEEP

KEEP

24

IF_

IF

25

FND7SE

FIND-7 without USING or with USING search-expression

26

ONLINE

UDS online utility

28

FND3SE

FIND-3 without USING

30

LONAM

LOOK for a name

31

LOREC

LOOK for a record

32

LOSET

LOOK for a set

33

LOITM

LOOK for an item

34

LOKEY

LOOK for a key

36

LORLM

LOOK for a realm

37

RDYGLO

Start a distributed transaction1

38

PTC

End initiation phase for distributed transaction1

125

RELBAS

RELOCATE RELOCATION-TYPE = *BASE-LEVEL-TABLE-PAGES

126

RELINX

RELOCATE RELOCATION-TYPE = *INDEX-LEVEL-TABLE-PAGES

127

RELDST

RELOCATE RELOCATION-TYPE = *DISTRIBUTABLE-TABLE-PAGES

128

RELREC

RELOCATE RELOCATION-TYPE = *RECORD-PAGES

129

FPASCA

FPASCAN

130

PRERLM

PREFRLM

131

REOPPP

REORGPPP

132

FTC1

FETCH-1

133

FTC5

FETCH-5

134

FTC4R

FETCH-4 without WITHIN or with WITHIN realmname

135

FTC4S

FETCH-4 with WITHIN setname

136

FTC6

FETCH-6

137

FTC2

FETCH-2

138

FTC7IS

FETCH-7 USING record-element-name,... (sequential search)

139

FTC7IK

FETCH-7 USING record-element-name,... (search with key)

140

FTC3IS

FETCH-3 USING record-element-name,... (sequential search)

141

FTC3IK

FETCH-3 USING record-element-name,... (search with key)

142

GET

GET

153

FTC7SE

FETCH-7 without USING or with USING search-expression

156

FTC3SE

FETCH-3 without USING

158

NLONAM

next LOOK for a name

160

NLOSET

next LOOK for a set

161

NLOITM

next LOOK for an item

162

NLOKEY

next LOOK for a key

164

NLORLM

next LOOK for a realm

Table 35: Function codes of the DML statements

1 Only in conjunction with UDS-D