×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I believe SYSINDEXES only includes true SQL indexes - the CREATE TABLE that defines this view includes IX.DBXATR = 'IX' - the attributes in QADBXREF are these - AL,AR,IX,LF,MQ,PF,TB,VW
So I think this is why the SYSFILES view was added at 7.3 - and since 7.4 it includes the based-on information.
From the documentation, note this, especially about native files - The SYSFILES view contains one row for every Db2® for i database file, including native files. This view includes attributes not returned by QSYS2.SYSTABLES.
Regards
Vern
On Tue, 2 Jan, 2024 at 3:44 PM, Hiebert, Chris <chris.hiebert@xxxxxxxxxxxxxx> wrote:
To: midrange systems technical discussion
You can try the SYSINDEXES SQL catalog view.
SELECT TABLE_NAME FROM SYSINDEXES WHERE INDEX_NAME ='FILENAME'
https://www.ibm.com/docs/en/i/7.5?topic=views-sysindexes
--
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Justin Taylor
Sent: Friday, December 29, 2023 8:29 AM
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
Subject: Get PF for LF
Is there an easy was to programmatically get the PF for a given LF? I was
hoping for a SQL Service, but I can't find one.
midrange.com
