RE: Field Type 'P' in a query

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

Understood.  Just keep in mind that WRKQRY was intended from the get-go to
be an end-user tool.  Yes, it has some capabilities that the tech staff can
use, but when dealing with an input file that is not externally described to
the system, and that is to say that each "field" in the record is not
explicitly defined in the system, then query is really not the most suitable
tool for that task.

One other thing and then I'll sign off on this topic.  *If* the record is
fixed-length format, where the fields in all records line up in columns, you
may want to define a new physical file (PF) using DDS so that the layout
matches the columns in the original file, then use CPYF with FMTOPT(*NOCHK)
to copy the original to the new file.  Once you get the data into an
externally described file, life becomes much easier.

db

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / Glenn Thompson
> Sent: Friday, October 29, 2004 11:02 AM
>
> Dan,
>
> I'm going to switch tactics at this point.  I will have to do this
> several more times as I'm doing a system implementation.  I'm going to
> have to brush up on my RPG skills which were poor at best.
>
> I have several more of these type tasks to complete and I thought a
> query might be the way to go.
>
> Thanks to you and Vern for your help.  I'm sure I'll be back with more
> questions about how to code and run my RPGILE program when I'm done.