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

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.