Actually I'm starting with an S/36 alternate index file. I know a DDS LF will fulfil my requirements, but DDS is deprecated so I'm trying not to use it.
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Wednesday, November 06, 2019 12:50 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Alt index to SQL keyed view
I understand that using a DDS LF in your Query may have been a good practice in the past. For example, with IIM being the table, IIML01 may be a LF with not only an index but also record selection. In our case, "Active" records only.
And while you want to replace your DDS LF's with SQL indexes you would like to continue that "one stop shopping". I don't think that's possible.
Some may say that you should query against the table and it would then use that index. However would it really? Wouldn't it rather use an index with an index not just over your "key" but shouldn't the index also include your "where" clause? So your index would have your active record id column, then any key, or order by, columns. That index would not work for existing code using RPG RLA. So it would have to be in addition to. And you would still query the table or a view when using sql.
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
Kendallville, IN 46755
As an Amazon Associate we earn from qualifying purchases.