RE: Field Type 'P' in a query

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

When you said COMP, I thought you were talking COBOL, and comparing that to
P-type field.

Defining a packed field in query?  Let me ask, is this an externally-defined
file you are querying?  It sounds like you might be dealing with a
"flat-file" with no external definition and, so, you have packed data in a
long character field you need to extract.  Is that it?

Otherwise, I have no idea why you need to explicitly define a packed field.

db

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / Glenn Thompson
> Sent: Thursday, October 28, 2004 11:24 AM
>
> Vern,
>
> I'm the one lacking understanding.  I believe I have erred in calling
> the field COMP.  It is indeed a packed field.  The question is can I
> define a packed field in a query.   And if so how do I do that?
>
> Vernon Hamberg wrote:
>
> > 'P' means a packed field - but I'm confused - COMP is valid only in
> > logical files, right? Are you trying to insert records through a
> > logical? Hope I'm not displaying ignorance here. Is there something
> > I'm not understanding?
> >
> > Cheers
> > Vern