Re: Help solve an argument: Reading a SQL index in RPG?

<snip>
Previously, when we added a field to a PF and recompiled all the LF's
that were based on the file, the new field was in the LF. Now we
don't have to recompile the indexes because the system takes care of
that for us.
</snip>

You're right, ONLY if you do NOT use the RCDFMT clause.

CREATE TABLE QTEMP.ROBBIE (MYCHAR CHAR (5 ) NOT NULL WITH DEFAULT)

Table ROBBIE created in QTEMP.

CREATE INDEX QTEMP.robbieidx ON QTEMP.ROBBIE (MYCHAR)

Index ROBBIEIDX created in QTEMP on table ROBBIE in QTEMP.

alter table qtemp.robbie

add column myint int

DSPFFD FILE(QTEMP/ROBBIEIDX)
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
MYCHAR CHAR 5 5 1 Both MYCHAR
Coded Character Set Identifier . . . . . : 37
MYINT BINARY 9 0 4 6 Both MYINT
Allows the null value

Now, let's try it again with the RCDFMT clause even with ADD ALL COLUMNS.

drop index qtemp.robbieidx

Drop of ROBBIEIDX in QTEMP complete.

drop table qtemp.robbie

Drop of ROBBIE in QTEMP complete.

CREATE TABLE QTEMP.ROBBIE (MYCHAR CHAR (5 ) NOT NULL WITH DEFAULT)

Table ROBBIE created in QTEMP.

CREATE INDEX QTEMP.robbieidx ON QTEMP.ROBBIE (MYCHAR) rcdfmt robbbiei

add all columns
Index ROBBIEIDX created in QTEMP on table ROBBIE in QTEMP.

alter table qtemp.robbie

add column myint int

DSPFFD FILE(QTEMP/ROBBIEIDX)
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
MYCHAR CHAR 5 5 1 Both MYCHAR
Coded Character Set Identifier . . . . . : 37
So, the

Rob Berendt