iSeries Query - Code behind

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kellyj00@gmail.com
    #1

    iSeries Query - Code behind

    We have clients who have not been exposed to SQL and have built a few
    thousand queries using the iSeries Query tool via their 5250 sessions.

    Is there any way to gather the code behind these queries that they have
    saved? Rather than opening each of them to reverse engineer how they
    work and rebuild them in SQL?

    Thank You!
    Jason

    Tags: None
    • DougDB
      #2
      Re: iSeries Query - Code behind

      On 19 Jan 2007 14:15:23 -0800, "kellyj00@gmail .com"
      <kellyj00@gmail .comwrote:
      >We have clients who have not been exposed to SQL and have built a few
      >thousand queries using the iSeries Query tool via their 5250 sessions.
      >
      >Is there any way to gather the code behind these queries that they have
      >saved? Rather than opening each of them to reverse engineer how they
      >work and rebuild them in SQL?
      >
      >Thank You!
      >Jason
      If not too late:

      RTVQMQRY - Retrieve Query Mgmt Query

      The Retrieve Query Management Query (RTVQMQRY) command allows you to
      retrieve Structured Query Language (SQL) source from a query
      management query (QMQRY) object. The source records are placed into
      an editable source file member.


      this includes iSeries (As/400, i5, System i....whatever) Query. Also
      make sure you use ALWQRYDFN(*YES)


        Comment

        Previous template Next
        Working...