× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



<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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.