Re: Converting from packed to character in Query/400

Carol writes:

> I found that I could convert the data to a character string in the Query
> which runs before the C program, by using the DIGITS function.  This is
> good, except that the DIGITS function does not retain the sign of the
> number. (!)  I have figured out a kludgey way of handling this, but I
> still wonder: Am I missing something obvious, or is there no easy way to
> do this?

I'm probably poking at the obvious, but is the DIGITS field big enough to hold
the sign? I've been bitten several times by thinking that a 5-place numeric
field only needed 5 (not six or seven) places for an *CHAR version of the same
value.

Peter H. Coffin
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *