Ten2008   730 pts.  |   Oct 7 2009  1:18PM GMT

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

CharlieBrowne   6350 pts.  |   Oct 7 2009  2:31PM GMT

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.

Voodoovw   1720 pts.  |   Oct 7 2009  2:33PM GMT

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