Re: Field Type 'P' in a query

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Cool. So is this a Query/400 query or an SQL query? In Query/400 you can 
define a result field and give it length and decimal positions. You can't 
say what kind of number, it just takes care of that, as I recall.

In SQL you can cast a value to a decimal, which is the same as packed. Just 
say decimal(number) - you can use optional length and decimal values.

I don't have the original post anymore - do you have second-level text on 
the message? Is it helpful?

Vern

At 10:24 AM 10/28/2004, you wrote:
> 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
>
> --
> Glenn Thompson
> Senior Analyst
> American Trouser, Inc.
> gthompson@xxxxxxxxxxxxxxxxxxxx
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.