Results 1 to 6 of 6

Thread: Retrieving Query Definition

  1. #1
    Swaps on AS400!
    Join Date
    Feb 2009
    Location
    Canada
    Posts
    107
    Rep Power
    518

    Question Retrieving Query Definition

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

  2. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

  3. #2
    Admin kitvb1's Avatar
    Join Date
    Aug 2007
    Location
    Stammbach, Germany
    Posts
    2,280
    Rep Power
    3857

    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.

  4. #3
    Analyst GLS400's Avatar
    Join Date
    May 2006
    Location
    connecticut
    Posts
    1,893
    Rep Power
    5783

    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

  5. #4
    Swaps on AS400!
    Join Date
    Feb 2009
    Location
    Canada
    Posts
    107
    Rep Power
    518

    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

  6. #5
    Swaps on AS400!
    Join Date
    Feb 2009
    Location
    Canada
    Posts
    107
    Rep Power
    518

    Re: Retrieving Query Definition

    Quote 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>?

  7. #6
    Harbinger of Doom tomholden's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Tennessee, United States
    Posts
    4,312
    Rep Power
    8621

    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

  8. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. Replies: 7
    Last Post: March 22nd, 2010, 12:30 PM
  2. Command Definition and processing
    By redvan in forum ANY THING GOES
    Replies: 1
    Last Post: November 6th, 2009, 08:36 AM
  3. Definition of IfNull() Fields
    By thosmore in forum PC programming as it relates to Iseries
    Replies: 0
    Last Post: August 21st, 2008, 04:46 PM
  4. Error in Array definition
    By snufse in forum RPG/RPGLE
    Replies: 2
    Last Post: January 4th, 2007, 11:16 AM
  5. about User Definition of Command
    By pl421 in forum RPG/RPGLE
    Replies: 2
    Last Post: September 3rd, 2005, 10:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •