ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Retrieving Query Definition

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Retrieving Query Definition

    I need to extract files used in query definition object - *QRYDFN. Is there any command to do so?

  • #2
    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.

    Comment


    • #3
      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
      GLS
      The problem with quotes on the internet is that it is hard to verify their authenticity.....Abraham Lincoln

      Comment


      • #4
        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


        • #5
          Re: Retrieving Query Definition

          Originally posted by GLS400 View Post
          Hi 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


          • #6
            Re: Retrieving Query Definition

            hawkeye will not give you the join info, etc but it will capture the files used by the query.
            I'm not anti-social, I just don't like people -Tommy Holden

            Comment

            Working...
            X