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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Thanks to Luis for clarifying this.

On 2/22/2016 9:46 AM, Vernon Hamberg wrote:
> A slight addition to Darren's comment on record format - when you 
> create an index withOUT the RCDFMT, the format name is the same as the 
> index name - so you have to use a RENAME in RPG. The RCDFMT clause was 
> added for IBM i to get around this.
>
> Vern
>
> On 2/22/2016 9:17 AM, darren@xxxxxxxxx wrote:
> > Use the index directly when using traditional RPG I/O.  Use the Table or
> > View when referencing with SQL.
> >
> > By the way, you'll need to add a record format to the Index to make it
> > usable by RPG.
> >
> > Here is an example from our source library:
> > CREATE INDEX EIXQL01 ON EIXQ (ECUST ASC, EPART ASC)
> > RCDFMT EIXQR;
> > LABEL ON INDEX EIXQL01 IS 'EIXQ by Cust, Part';
> >
> > > One of my co-workers insists on using the SQL indexes we've built as
> > > if they are tables and reading them directly.
> > >
> > > I've been trying to convince him that indexes are intended ONLY to
> > > boost performance on table & view access and that, if he wants to read
> > > a table in a specific key order, he should build a keyed view over the
> > > table.
> > >
> > > Unfortunately, he won't budge on this ... I'd like to present him with
> > > some IBM documentation explaining indexes are for performance purposes
> > > only and that they shouldn't be read directly.
> > >
> > > I've shown him that you will get a SQL7011 error if you try to read an
> > > index using a select statement, but he thinks it's fine to read the
> > > index using native RPG I/O because the index is implemented as a
> > > logical file.
> > >
> > > Can anyone point me to an IBM document (preferably on ibm.com) that
> > > explains that indexes are for performance purposes only?
> > >
> > > Thanks!
> > >
> > > Rob M
> > > --
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.