IBM AS/400 manual Valid File Operations

Valid File Operations

When	you update or add a record to a file	by	relative record numb
must	already have a place in the member. For	an	update,	that	place
valid	existing record; for a new record, that	place must		be	a delet

You can use the CL command INZPFM to initialize records for use by re record number. The current relative record number is placed in the RE all retrieval operations or operations that reposition the file (for e CHAIN, READ).

Valid File Operations

Table 20 on page 305 shows the valid file operation codes allowed for D processed by keys and Table 21 on page 306 for DISK files processed keyed methods. The operations shown in these figures are valid for e described DISK files and program-described DISK files.

Before running

your

program, you

can

override

a

file

to

another

file.

you can override a sequential file

in

your

program

to

an

externally

d

file.

(The file is

processed

as

a

sequential

file.)

You can

also

ove

in your program to another keyed file, providing

the

key

fields

are

example, the overriding file must

not

have

a

shorter

key

field

than

y

your

program.

Note: When

a

database

record is deleted, the physical record is mar

deleted. Deleted

records

can

occur

in

a

file if the file has

with deleted records using the Initialize

Physical

File

Member

(

command. Once a record is

deleted,

it

cannot

be

read.

However,

use the relative record-number

to

position

to

the

record

and

the

its

contents.

304 ILE RPG for AS/400 Programmer's Guide