RE: WRKQRY

["Anita Imbrescia" <aimbresc@xxxxxxxxxxxxxxxxxxxxx>]

On the Work with Queries screen, type a 6, the query name and your
library.  Type WRKSPLF on a command line and look for output with
today's date, usually named QPQUPRFIL.  That should give you the field
names on the file in the query, along with sorts, selects etc.  Hope
that's what you want. 

Anita Imbrescia
Westmoreland County Information Systems
aimbresc@xxxxxxxxxxxxxxxxxxxxx
724-830-3758
 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeffrey Lee
Sent: Tuesday, June 29, 2004 10:27 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: WRKQRY

When I do this I still dont see the source. I see the files contents to
the
right and some garbled text to the left. My objective here is to get the
variable names of each field so that I can use that data in another
program.

----- Original Message ----- 
From: <michaelr_41@xxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 29, 2004 9:21 AM
Subject: Re: WRKQRY


> Try DSPPFM library/file. If you get a 'File not found' message, check
> your spelling, because you would only get that message if either the
> file didn't exist in the library or the library doesn't exist.
>
> On Tue, 29 Jun 2004 09:16:21 -0500, "Jeffrey Lee"
> <jeff@xxxxxxxxxxxxxxxxxxx> said:
> > 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.
> >
> -- 
>
>   michaelr_41@xxxxxxxxxxxxxx
>
> --
> 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.