RE: sql scale, decimal, help..

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
That worked...  Thank you...

tim

> -----Original Message-----
> From: Vern Hamberg [SMTP:vhamberg@centerfieldtechnology.com]
> Sent: Monday, December 30, 2002 5:23 PM
> To:   midrange-l@midrange.com
> Subject:      Re: sql scale, decimal, help..
>
> Tim
>
> If I understand this, try dividing by 100.0 - might need to cast one of
> the
> operands with the decimal() function.
>
> HTH
>
> Vern
>
> At 03:58 PM 12/30/02 -0800, you wrote:
> >This message is in MIME format. Since your mail reader does not
> understand
> >this format, some or all of this message may not be legible.
> >--
> >[ Picked text/plain from multipart/alternative ]
> >I have an integer 100, but it really represents $1.00  Is there an sql
> >function I can use on the update, to force/cast/convert it to two decimal
> >places?
> >update exdbfa/expplvhtim set vhvexp = 100
> >
> >But I really want to to be:
> >   update exdbfa/expplvhtim set vhvexp = 1.00
> >  but I don't have the ability to manipulate the variable, before the SQL
> >command, I can only altar the update statement...
> >
> >my db2 field is defined as 17,2  so it can can handle the data
> correctly...
> >
> >thanks, tim
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.