Re: Listing Files

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.