RE: Field Type 'P' in a query

Glenn, are you querying an externally described file?  If not sure, do a
DSPFD on the file and scan for "Externally described file" to see if it's
Yes or No.

Second-level text:  When you see a message at the bottom of the screen,
place your cursor on the message and press F1; this should bring up another
screen that shows more detail on the message.  If you're viewing a job log
via DSPJOBLOG, move the cursor to any message you're interested in and press
F1; same thing.

hth,
db

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / Glenn Thompson
> Sent: Thursday, October 28, 2004 1:14 PM
>
> 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