Re: changing keys of a physical file

["Richard Theis" <theis_richard@xxxxxxxxxx>]

<snip>
I believe these are even usable in RPG for keyed access - VIEWs are not, as

they are only encapsulated SQL SELECT statements and have no data, no true
path to the data until the SQL statement is run.
</snip>

Yes, IDXs are usable in RPG (the format name is the table name). VIEWs are
usable also (no keyed access, of course).  For TABLEs and VIEWs, in order
to use them in RPG, it's convenient to create them with the desired future
format name, and then to rename them with the definite object name.
As of constraints, neither the UNIQUE DDS keyword nor the CREATE UNIQUE
INDEX are adding primary or unique constraints.  The only way is to use
ADDPFCST or CREATE/ALTER TABLE.

HTH

BTW, I just cannot understand why to change a primary key : it should had
been determined thru the relational normalization process, has dependencies
on referential integrity, and so on...

Bonne réception/Best regards
Richard THEIS
  Education iSeries 400, France
    theis_richard@xxxxxxxxxx