query/400

1150 pts.
Tags:
AS/400 database
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
publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/books/sc415210.pdf

For DB2 Web Query start here
www-03.ibm.com/systems/i/software/db2/webquery

Voodoo

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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.
    41,370 pointsBadges:
    report
  • 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:
    report
  • 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...  
    255 pointsBadges:
    report
  • 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:
    report
  • 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.  
    8,100 pointsBadges:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following