Re: Finding an object's usage

["rick baird" <rick.baird@xxxxxxxxx>]

I don't believe so.  If you load the data into the an ext data
structure using the file name, it would see that reference, not the
SQL one.

On 3/22/07, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> DSPPGMREF actually handles Static sql quite well, (much to my surprise).
> But it doesn't handle Dynamic sql like
> C                   eval      HostVar='Select loc, comp, coname ' +
> C                                      'from aaakey ' +
> C                                      'order by '  + SortCol +
> C                                      'for fetch only'
> Would a Hawkeye product show a reference to file AAAKEY for that?
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "rick baird" <rick.baird@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 03/22/2007 01:01 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> Re: Finding an object's usage
>
>
>
>
>
>
> no single command (unless you own hawkeye's pathfinder)
>
> DSPPGMREF *ALL will get all program references, but you'll have to
> look for queries and other stuff another way.
>
> On 3/22/07, Nick_Radich@xxxxxxxxxxxxxx <Nick_Radich@xxxxxxxxxxxxxx> wrote:
> > Hello everyone,
> >
> > Is there a Command I can run, or a system file I can query, that will
> show
> > me all of the objects on my system that reference a particular file?
> >
> > We are at V4R5.
> >
> >
> > Thanx,
> >
> > Nick
> >
> >
> >
> > Nick Radich
> > Sr. Programmer/Analyst
> > EPC Molding, Inc.
> > Direct  (320) 679-6683
> > Toll free  (800) 388-2155  ext. 6683
> > Fax  (320) 679-4516
> > nick_radich@xxxxxxxxxxxxxx
> > --
> > 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.
>
>
> --
> 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.