|
<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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.