I need to extract files used in query definition object - *QRYDFN. Is there any command to do so?
Announcement
Collapse
No announcement yet.
Retrieving Query Definition
Collapse
X
-
Re: Retrieving Query Definition
1. You can dump the query and you will find the files listed new the bottom of the printout. The information is not always given though.
2. You can use the X-Cmd (search this site) which also dumps the query.
3. You can use the XrefIT. The free version will return proper results.
Point 1 is as at v5r4, I am not sure if IBM have improved things in v6/7.Regards
Kit
http://www.ecofitonline.com
DeskfIT - ChangefIT - XrefIT
___________________________________
There are only 3 kinds of people -
Those that can count and those that can't.
-
Re: Retrieving Query Definition
Hi swaps400:
See Mercury's post here:
http://www.code400.com/forum/archive/index.php?t-9396.html
Best of Luck
GLSThe problem with quotes on the internet is that it is hard to verify their authenticity.....Abraham Lincoln
Comment
-
Re: Retrieving Query Definition
Thanks Everyone,... I think I tried RTVQMQRY on *QRYDFN but it did not work. I will confirm it tomorrow. I also have hawkeye pathfinder, but havent used so far. I will explore that one to see if there is any option to extract query definition.
Thanks
Swaps
Comment
-
Re: Retrieving Query Definition
Originally posted by GLS400 View PostHi swaps400:
See Mercury's post here:
http://www.code400.com/forum/archive/index.php?t-9396.html
Best of Luck
GLS
RTVQMQRY worked ... I think this will be best way to extract file usage. Anyone knows about Hawkeye usage for the same purpose>?
Comment
Comment