MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

Re: Field Type 'P' in a query



fixed

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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact