IBM AS/400 manual Valid File Operations, an A,P,G,D,T,Z, Accessing Database 305Files

Valid File Operations

Table

20. Valid File Operations for Keyed Processing Methods (Random by Key,

Sequential

by

Key,

Sequential

within Limits)

File-Description

Calculation

Specifications

Positions

Specifications

Positions

17

18

20

28

1

2

26-35

34

I

P/S

K/A/P/G/

CLOSE,

FEOD,

FORCE

D/T/Z/F

I

P/S

A

K/A/P/G/

WRITE,

CLOSE,

FEOD,

FORCE

D/T/Z/F

I

P/S

L

K/A/P/G/

CLOSE,

FEOD,

FORCE

D/T/Z/F

U

P/S

K/A/P/G/

UPDATE,

DELETE,

CLOSE,

FEOD,

D/T/Z/F

FORCE

U

P/S

A

K/A/P/G/

UPDATE,

DELETE,

WRITE,

CLOSE,

D/T/Z/F

FEOD,

FORCE

U

P/S

L

K/A/P/G/

UPDATE,

DELETE,

CLOSE,

FEOD,

D/T/Z/F

FORCE

I

F

K/A/P/G/

READ,

READE,

READPE,

READP,

D/T/Z/F

SETLL,

SETGT,

CHAIN,

OPEN,

CLOSE,

FEOD

I

F

A

K/A/P/G/

WRITE,

READ,

READPE, READE,

D/T/Z/F

READP,

SETLL,

SETGT,

CHAIN,

OPEN,

CLOSE,

FEOD

I

F

L

K/A/P/G/

READ,

OPEN,

CLOSE,

FEOD

D/T/Z/F

U

F

K/A/P/G/

READ,

READE,

READPE,

READP,

D/T/Z/F

SETLL,

SETGT,

CHAIN,

UPDATE,

DELETE,

OPEN,

CLOSE,

FEOD

U

F

A

K/A/P/G/

WRITE,

UPDATE,

DELETE,

READ,

D/T/Z/F

READE,

READPE,

READP,

SETLL,

SETGT,

CHAIN,

OPEN,

CLOSE,

FEOD

U

F

L

K/A/P/G/

READ,

UPDATE,

DELETE,

OPEN,

D/T/Z/F

CLOSE,

FEOD

O

Blank

A

K/A/P/G/

WRITE

(add

new

records

to

a

file),

D/T/Z/F

OPEN, CLOSE,

FEOD

O

Blank

K/A/P/G/

WRITE

(initial

load

of

3,a

OPEN,new

file)

D/T/Z/F

CLOSE,

FEOD

Notes:

1. An L

must

be

specified

in

position

28

to

specify sequential-within-limits

a record-address file for

an input or an update file.

2. Externally

described

filesK

inrequirepositiona 34;

program-described

files requir

an A,P,G,D,T,Z,

orF

in

position

34 I andin

anposition

35.

3. An A

in

position

20

is

not

required

for

the

initial

loading A of records

is specified in positionADD must20,be specified

on

the

output

specifications.

file

must

have

been

created with

the

OS/400

CREATE

FILE

command.

Chapter 16. Accessing Database 305Files