Re: Has anyone ever created an Index Table that included a JOIN table

Hi Tim

So far as I know, there is no such thing as an "index table" on IBM i. I could not find that term in the SQL Reference for version 7.5.

Every index is built over a specific table - here is a bit from the SQL Reference - "An index is a set of pointers to rows of a base table. Each index is based on the values of data in one or more table columns. An index is an object that is separate from the data in the table."

So, by definition, every index is built over a specific table.

Now a DDS JOIN logical file can have key fields. That sounds like what you want. I don't think there is an equivalent SQL object type.

Cheers
Vern

On 5/6/2024 7:17 AM, Timothy Feldmeier wrote:

Vern, an Index table is an Index over a specific table. I would like to add a join to the Index table. Can this be done? I do not want a view—as a view is just a temporary path.

The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.