Re: WRKQRY

[RPower@xxxxxxxxxx]

                              Work with Queries 
 
Type choices, press Enter. 
 
  Option  . . . . . .                  1=Create, 2=Change, 3=Copy, 
4=Delete
                                       5=Display, 6=Print definition 
                                       8=Run in batch, 9=Run 
  Query . . . . . . .                  Name, F4 for list 
    Library . . . . .                  Name, *LIBL, F4 for list 

In the above screen is where you specify a name for your qry and the 
library to create the qry, not the file or member you want to qry.  That's 
the next screen:
                               Define the Query 
 
Query . . . . . . :   TEST1             Option  . . . . . :   CREATE 
  Library . . . . :     PGMRRP          CCSID . . . . . . :   65535 
 
Type options, press Enter.  Press F21 to select all. 
  1=Select 
 
Opt    Query Definition Option 
 1     Specify file selections 
       Define result fields 
       Select and sequence fields 
       Select records 
       Select sort fields 
       Select collating sequence 
       Specify report column formatting 
       Select report summary functions 
       Define report breaks 
       Select output type and output form 
       Specify processing options 
 
F3=Exit            F5=Report          F12=Cancel 
F13=Layout         F18=Files          F21=Select all 

Followed by the file selection screen:
                           Specify File Selections 
 
Type choices, press Enter.  Press F9 to specify an additional 
  file selection. 
 
  File . . . . . . . . .                  Name, F4 for list 
    Library  . . . . . .     TAXES        Name, *LIBL, F4 for list 
  Member . . . . . . . .   *FIRST         Name, *FIRST, F4 for list 
  Format . . . . . . . .   *FIRST         Name, *FIRST, F4 for list 
 
 
 
 
 
 
 
 
 
 
 
 
F3=Exit           F4=Prompt          F5=Report            F9=Add file 
F12=Cancel        F13=Layout         F24=More keys 


I think this is where you want to be.  I still don't see my emails going 
to the list though....

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




"Jeffrey Lee" <jeff@xxxxxxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/29/2004 11:54 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: WRKQRY






Well I just enter WRKQRY and fill out the fields.

>From there I type 2 for edit
OEPEHDA for the query
and MODSMR for the library.

Those are the only 3 places to enter data

----- Original Message ----- 
From: "Rubino, Jim" <Jim.Rubino@xxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 29, 2004 9:19 AM
Subject: RE: WRKQRY


> Are you specifying the member name on the wrkqry command?  You have to
tell
> it what the source file member name is for it to find the data.
>
>
>     Jim Rubino
> Senior Programmer Analyst
> FIKE CORPORATION (r)
> 704 South 10th Street
> Blue Springs, Mo.  64015
> Direct Dial - (816)  655-4579
> Or - (816)  229-6216  Ext. 1079
>
>
>
>
>
> -----Original Message-----
> From: Jeffrey Lee [mailto:jeff@xxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, June 29, 2004 9:16 AM
> To: RPG programming on the AS400 / iSeries
> Subject: WRKQRY
>
>
> I am trying to view the source of a file with WRKQRY but it keeps saying
> that the file is not in that library... when it is. The file (oepehda) 
is
in
> the library modsmr. I want to view its source (normally I can only 
change
it
> using DFU) but WRKQRY isnt working for me. Is there something else I can
> try? I am new at the AS/400 so bear with me here.
>
> Thanks,
> Jeff
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
list
> To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, 
unsubscribe,
or
> change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




This OutBound email has been scanned for Viruses