Filter
Top Products
Valid File Operations
Table 20. Valid File Operations for Keyed Processing Methods (Random by Key,
Sequential by Key, Sequential within Limits)
File-Description
Specifications Positions
Calculation Specifications Positions
17 18 20 28
1
34
2
26-35
I P/S K/A/P/G/
D/T/Z/F
CLOSE, FEOD, FORCE
I P/S A K/A/P/G/
D/T/Z/F
WRITE, CLOSE, FEOD, FORCE
I P/S L K/A/P/G/
D/T/Z/F
CLOSE, FEOD, FORCE
U P/S K/A/P/G/
D/T/Z/F
UPDATE, DELETE, CLOSE, FEOD,
FORCE
U P/S A K/A/P/G/
D/T/Z/F
UPDATE, DELETE, WRITE, CLOSE,
FEOD, FORCE
U P/S L K/A/P/G/
D/T/Z/F
UPDATE, DELETE, CLOSE, FEOD,
FORCE
I F K/A/P/G/
D/T/Z/F
READ, READE, READPE, READP,
SETLL, SETGT, CHAIN, OPEN, CLOSE,
FEOD
I F A K/A/P/G/
D/T/Z/F
WRITE, READ, READPE, READE,
READP, SETLL, SETGT, CHAIN, OPEN,
CLOSE, FEOD
I F L K/A/P/G/
D/T/Z/F
READ, OPEN, CLOSE, FEOD
U F K/A/P/G/
D/T/Z/F
READ, READE, READPE, READP,
SETLL, SETGT, CHAIN, UPDATE,
DELETE, OPEN, CLOSE, FEOD
U F A K/A/P/G/
D/T/Z/F
WRITE, UPDATE, DELETE, READ,
READE, READPE, READP, SETLL,
SETGT, CHAIN, OPEN, CLOSE, FEOD
U F L K/A/P/G/
D/T/Z/F
READ, UPDATE, DELETE, OPEN,
CLOSE, FEOD
O Blank A K/A/P/G/
D/T/Z/F
WRITE (add new records to a file),
OPEN, CLOSE, FEOD
O Blank K/A/P/G/
D/T/Z/F
WRITE (initial load of a new file)
3
, OPEN,
CLOSE, FEOD
Notes:
1. An L must be specified in position 28 to specify sequential-within-limits processing by
a record-address file for an input or an update file.
2. Externally described files require a K in position 34; program-described files require
an A,P,G,D,T,Z, or F in position 34 and an I in position 35.
3. An A in position 20 is not required for the initial loading of records into a new file. If A
is specified in position 20, ADD must be specified on the output specifications. The
file must have been created with the OS/400 CREATE FILE command.
Chapter 16. Accessing Database Files 305