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

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.

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

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…
 

If you’ve never used Query/400, don’t start using it. Use Query Manager instead. Use the STRQM command. — Tom

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.