1150 pts.
AS/400 database
IBM iSeries
plz tell me how to work with query/400 on as/400 machine...thanks

Software/Hardware used:
as/400,IBM i

Answer Wiki

Thanks. We'll let you know when a new response is added.

For the AS400 Query start with WRKQRY
Here is the Query manual

For DB2 Web Query start here


Discuss This Question: 6  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ten2008
    Hi, thanks for your reply. But even after read this article i couldn't understand from wherein i can create the query, Please answer this... thanks Ram
    1,150 pointsBadges:
  • CharlieBrowne
    From a command line enter WRKQRY Enter option 1 and the name your want to give the query and the library you want to store the program. Press Enter 2 times. This will bring up a screen to allow you to enter the filename and library of the file you want to query. HIt enter until you get back to the Define the Querty Screen. At this point you can do F5 and it will run the query and display the results. Hit enter to go back to Define the query screen. Now you can use option 1 to select scrrens that will allow you to take more options to refine the query. When you have completed all that, do F3. This will allow you to save the query for later use.
    62,385 pointsBadges:
  • Voodoovw
    Hi Ram, For the AS400 Query start with the command WRKQRY On the command line type WRKQRY <Press Enter> Option . . . . . . 1 1=Create Query . . . . . . . MYQUERY <== What you want to call your query Library . . . . . YOURLIB <== The library you want to save your query to Voodoo
    1,735 pointsBadges:
  • sivakesava
    From command line enter GO QUERY or STRQRY and hit enter, it shows options like   1. Work with queries       2. Run an existing query  3. Delete a query                                 press any option or type commands like (wrkqry,runqry,dltqry) for the above three options respectively...  
    285 pointsBadges:
  • TomLiotta
    If you've never used Query/400, don't start using it. Use Query Manager instead. Use the STRQM command. -- Tom
    125,585 pointsBadges:
  • ToddN2000
    DON'T DO IT !! I agree with Tom. If you are just starting out use Query Manager. It's a lot easier to maintain going forward with changes.  
    136,350 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: