Re: More fun with native RLA on an SQL view

James,

From IBM's DBMAG online magazine:

CREATE INDEX STARTEST.BIGREVENUE ON STARTEST.ITEM_FACT (SUPPKEY ASC,
QUANTITY * EXTENDEDPRICE ASC)
WHERE QUANTITY * EXTENDEDPRICE > 100000
RCDFMT BSUPPREV ADD QUANTITY, EXTENDEDPRICE, REVENUE_WO_TAX, REVENUE_W_TAX;

Yes, maybe it is not "pure" SQL but it can make life easier for migrating
old DDS LFs.

When I wrote about my coworkers's programs I meant RPGLE programs. I have
read some views using CLP. I don't why it should be different for MI
programs, though.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, Apr 15, 2010 at 11:37 AM, James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

Luis Rodriguez wrote:

IIRC, you can specify a record format for an index with V6R1.

Also, How are you doing the RLA of your view? Could you give us an

example?

From MI.

About as much of the code as I can give is posted with the
separate-but-related problem I put on the MI list.

I'm trying to arrange to see what an RPG program does with the view (at
the moment, I have no access to the box whereon this is happening).

And if it is possible to specify a format (a format, or just a format
name?) for an index, that's news to me, and while welcome, it also
sounds like something completely foreign to SQL being grafted onto it.

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