Re: Finding an object's usage

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.