Re: Field Type 'P' in a query

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

There's no need to force it to packed - can't anyway. DanB's explanation of 
second-level text should get you to something, assuming you are getting a 
message about the mismatch. Can you tell us if you are getting a message, 
maybe put screen shots in your next post. Mismatch usually means between 
numeric and character. We need more specifics, I'm afraid.

Vern

At 12:14 PM 10/28/2004, you wrote:
> This is Query/400.  Is there a way to force it to packed?  Am I going to 
> have to code RPG for this?
>
> I don't know what second-level text is.
>
> Thanks again.
>
> Vernon Hamberg wrote:
>
> > 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:
>
> --
> 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.