Re: Listing Files

Rob,

I'm not very sure, but I believe that the table QSYS/QADBFDEP will
catch all the dependent files:

SELECT DBFFDP, DBFLDP, DBFTDP FROM QADBFDEP WHERE DBFFIL = 'MYTABLE'

DBFFDP = Name of LF/Index/View
DBFLDP = Library Name
DBFTDP = Type of dependency: D-Data, V-View, I-Indirect


HTH,

Luis Rodriguez

On 8/12/10, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:

If you know vb.net then you probably have some familiarity with MS SQL
Server. Much of what you can use there can be used here. For example,

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME
FROM SYSTABLES
WHERE SYSTEM_TABLE_SCHEMA='MYLIB'

SELECT SYSTEM_VIEW_SCHEMA, SYSTEM_VIEW_NAME
FROM SYSVIEWS
WHERE SYSTEM_VIEW_SCHEMA='MYLIB'

SELECT SYSTEM_INDEX_SCHEMA, SYSTEM_INDEX_NAME,
SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME
FROM SYSINDEXES
WHERE SYSTEM_INDEX_SCHEMA='MYLIB'

May not catch 'all' LF's but will this work for you?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: bdietz400@xxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 08/12/2010 08:49 AM
Subject: Re: Listing Files
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Maybe you can find some useful info here:
http://www-03.ibm.com/systems/i/software/access/windows/toolkit/index.html

Bryan


On Aug 12, 2010 7:01am, Chamara Withanachchi <chamaraw@xxxxxxxxxx> wrote:

Dear All,

I know this question does not belong here, but don't know where to put

it.

Does any one know how to list down PF and LF in a library using VB .NET

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


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